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.
Nancy P. Tracy
Electrical Design and Web Development
GE Global Controls Services
3800 N. Wilson Ave.
Loveland, CO 80538
970.461.5273
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]