Use cfqueryparam.
-----Original Message-----
From: Howell, Craig H Civ WRALC/ITMS [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 25, 2007 8:26 AM
To: CF-Talk
Subject: CF list/SQL Quote Problem
Good Morning,
I have a CF list of items with single quotes around them (e.g., list =
'ABC', 'DEF', 'XYZ')
I am trying to use this list in a T-SQL statement using "IN":
SELECT *
FROM test-table
WHERE test-row IN (#list#)
The problem is T-SQL adds quotes and I end up with the following
statement:
SELECT *
FROM test-table
WHERE test-row IN (''ABC'', ''DEF'', ''XYZ'')
Any idea how to stop these additional quotes?
Thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Enterprise web applications, build robust, secure
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289416
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
