Sure.
Use ListQualify:
<cfscript>
list="203,197";
WriteOutput(list&"<br>");
fixlist=ListQualify(list,"'");
WriteOutput(fixlist);
</cfscript>
203,197
'203','197'
Robert Everland wrote:
>I have a query that I had been just comparing one value so I could use a
>cfqueryparam of varchar, now that same variables may be passing something
>like 203,197 meaning that a sales rep belongs to each of those groups. So I
>need to change my query to something IN ('203','197') , but cfqueryparam
>doesn't let me do this. Do I need to use something else besides cfqueryparam
>or is there a setting I am not seeing that will allow me to use cfqueryparam
>and this?
>
>[snip]
>
>
>
--
Kreig Zimmerman : Sr. Web Programmer : [EMAIL PROTECTED]
Four Eyes Productions : Brooklyn, NY : [718]254-9557 x[104]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
