Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] change multi-select prompt values
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] change multi-select prompt values
 Login/Join
 
Platinum Member
posted
Hi,

I got a HTML page with an multiselect dropdown box. This is filled with the months.
Result in fex is ''01' OR '02' OR '07'' I like to change this to 01 , 02 , 07 so I can use this as a IN statement in sql.
Does anyone have an idea how to accomplish this?

Kind regards

Mark

This message has been edited. Last edited by: FP Mod Chuck,
 
Posts: 103 | Registered: March 18, 2008Reply With QuoteReport This Post
Virtuoso
posted Hide Post
First : in your HTML page change your control setting under "Multiple: Add Quotes" to "No"

Second : look at STRREP function to change "OR" by comma


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2351 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Oke, thanks
I got it working.
 
Posts: 103 | Registered: March 18, 2008Reply With QuoteReport This Post
Virtuoso
posted Hide Post
My pleasure.

Please, edit your first (bottom right icon : a folder with a pen) post then add [SOLVED] at the beginning of the post's subject.


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2351 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] change multi-select prompt values

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.