Try it like this:
<cfset itemNames = "211D1234','211D4567">
<cfquery name="getOpenItems" datasource="myDS">
SELECT * FROM CADMODEL WHERE ITEMNAME IN (<cfqueryparam
cfsqltype="cf_sql_varchar" value="#itemNames#" list="yes">)
</cfquery>
(Honestly, it's because CF is escaping your single quotes. But, this is the
best way to fix that.)
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, July 26, 2004 11:29 AM
Subject: Weird SQL query behavior
> This one has me really confused. Can anybody tell me why 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.
>
> 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]
