preserveSingleQuotes(list)
Howell, Craig H Civ WRALC/ITMS wrote:
> 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.
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289415
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
