Thanks....that was easy.
-----Original Message-----
From: Nicholas M Tunney [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 25, 2007 9:30 AM
To: CF-Talk
Subject: Re: CF list/SQL Quote Problem
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.
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289417
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
