> this query returns three records
>
> <cfquery name="getOpenItems" datasource="myDS">
> SELECT * FROM CADMODEL WHERE ITEMNAME IN
> ('211D1234','211D4567') </cfquery>
>
> And this query returns an empty recordset?
>
> <cfset itemNames = "211D1234','211D4567"> <cfquery
> name="getOpenItems" datasource="myDS">
> SELECT * FROM CADMODEL WHERE ITEMNAME IN
> ('#itemNames#') </cfquery>
>
> I'm querying an Access database and using CFMX 6.1.
I suspect your single quotes in the itemNames variable are being doubled. CF
does this by default. Check out the PreserveSingleQuotes function to fix
this.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
