In my cold fusion application I have a multiple select list. Once data is select from the multiple select list it is passed to an oracle procedure as an in parameter and used in the IN clause of my query.
Im using the following cold fusion code to pass comma separated values to procedure from cold fusion multiple select list:
<CFSET v_list = #ListChangeDelims(FORM.listRight,"','", ",")#>
And used it in my procedure call as follows:
<cfprocparam dbvarname="p_list_right" cfsqltype="cf_sql_varchar" value=#v_list# type="in">
The above works fine if there is no commas in the listRight string. In case there are commas, no data set is returned. How do I resolve this issue? I was asked to use array, by not sure.