Re: MS SQL - Syntax error for valid query

["paross1" <webforumsuser@xxxxxxxxxxxxxx>]

Per the definition of the PreserveSingleQuotes() function:

 Description
 Prevents ColdFusion from automatically escaping single-quotation mark 
characters that are contained in a variable. ColdFusion does not evaluate the 
argument.

 Usage
 This function is useful in SQL statements to defer evaluation of a variable 
reference until runtime. This prevents errors that result from the evaluation 
of a single-quote or apostrophe data character (for example, "Joe's Diner") as 
a delimiter. 

 Example B: Consider this code:

 <cfset list0 = " '1','2', '3' ">
 <cfquery sql = "select * from foo where bar in (#list0#)">

 ColdFusion escapes the single-quote characters in the list as follows:
 ""1"", ""2"", ""3""

 The cfquery tag throws an error.

 You code this function correctly as follows:

 <cfquery sql = "select * from foo where bar in 
(#preserveSingleQuotes(list0)#)"> 
 This function ensures that ColdFusion evaluates the code as follows:
 '1', '2', '3' 

 Phil