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