What is the actual value of the variable you are plugging into the cfqueryparam? As I stated the other day I do not think the value needs any quotes at all in it when using a cfqueryparam with the list attribute. Also as others have stated you do not need to worry about preserving single quotes when using a query param. I do not have Access on this machine to test this, but it does work with MSSQL 2005 Express and CF7.
<cfset lstTest = "A,B,C" /> <cfquery name="qryTest" datasource="#Application.DataSource#"> SELECT * FROM TESTTABLE WHERE TEST IN (<cfqueryparam value="#Variables.lstTest#" cfsqltype="cf_sql_varchar" list="yes" />) </cfquery> <cfdump var="#qryTest#" /> On 6/25/06, Will Tomlinson <[EMAIL PROTECTED]> wrote: > > >Did you also try not using QuotedValueList to build the list in the first > >place? > > Originally I used ValueList(), but that returned 0 records. > > It seems like it's the cfqueryparam screwin things up. I tried valuelist() > with cfqueryparam and without... returned 0 records > > I used quotedvaluelist() with cfqueryparam, it returned 0 records. > > I used quotedvaluelist() without cfqueryparam, it returned the records I > needed. > > Maybe somebody else could run a simple test w/access to see what the issue > is here? > > Thanks, > Will > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244769 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
