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
MarkThis 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