RE: CF list/SQL Quote Problem

2007-09-25 Thread Dave Watts
> Any idea how to stop these additional quotes? PreserveSingleQuotes() Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia,

RE: CF list/SQL Quote Problem

2007-09-25 Thread Howell, Craig H Civ WRALC/ITMS
Thanksthat 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

Re: CF list/SQL Quote Problem

2007-09-25 Thread Nicholas M Tunney
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 (

RE: CF list/SQL Quote Problem

2007-09-25 Thread Dawson, Michael
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&#

CF list/SQL Quote Problem

2007-09-25 Thread Howell, Craig H Civ WRALC/ITMS
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