Focal Point
[SOLVED] change multi-select prompt values

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6687034686

May 17, 2017, 07:47 AM
MrM
[SOLVED] change multi-select prompt values
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,
May 17, 2017, 08:22 AM
MartinY
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
May 18, 2017, 12:54 AM
MrM
Oke, thanks
I got it working.
May 18, 2017, 08:31 AM
MartinY
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