That is because when in a cfquery it gets escaped out, so double quotes and why you would need to use PreseveSingleQuotes() around it. Maybe my mind is failing me but I do not think you need to worry about any of these functions and just do <cfqueryparam value="#TheList#" cfsqltype="cf_sql_varchar" list="yes" /> at least I'd swear that is how I have done it with Oracle in the past and would think the cfqueryparam handles it just as well with Access.
On 6/24/06, Will Tomlinson <[EMAIL PROTECTED]> wrote: > > >Will, try thelist = quotedvaluelist(yourquery.fieldname) > instead. That'll > >create a list "'item1','item2'...." which can be used in your 2nd where > >clause. > > > One thing that was strange is, the list I created did indeed have the > single quotes when I dumped it. > > But when it showed up in the SQL, it had double quotes. > > Will > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244730 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
