CF provides a nice function for the single-quotes issue you're running
into. Try this:
<!--- Note that there a NO single quotes here --->
<cfset itemNames = "211D1234,211D4567">
<!--- Listqualify takes care of it for you --->
<cfquery name="getOpenItems" datasource="myDS">
SELECT * FROM CADMODEL WHERE ITEMNAME IN (#listQualify(itemNames, "'")#)
</cfquery>
-Joe
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
