<cfset theList = valueList(myQuery.column) /> <cfset theList = listQualify(theList, "'") /> <!--- 2nd argument is a single quote, delimited by double quote --->
WHERE thefield IN <cfqueryparam value="#preservesingleQuotes(theList)#" cfsqltype="cf_sql_char" list="yes" /> the preserveSingleQuotes is probably extraneous as i believe <cfqueryparam> won't double them up the way cf normally does. not 100% sure tho, so try it with and without. > Charlie, could you give me a quickie example? you're lucky you said "example" :) On 6/24/06, Will Tomlinson <[EMAIL PROTECTED]> wrote: > >listQualify() and preserveSingleQuotes() > > > ><cfqueryparam> for good measure :) > > > Charlie, could you give me a quickie example? > > Thanks much! > > Will > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244722 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
