Re: MS SQL - Syntax error for valid query

[Ian Skinner <iskinner@xxxxxxxxxxx>]

AWFrueh1808 wrote:
> Gotcha.  So the single quotes are indeed only escaped as part of a SQL 
> statement (or more accurately, as part of a CFQUERY.  When you CFOUTPUT the 
> same variable, the quotes will not be escaped?

Yes they are only escaped when inside a <cfquery...> block to build the 
SQL statement that is sent to the database.  Thus the 
preserveSingleQuotes() parameter is only meaningful inside a 
<cfquery...> block.  Otherwise it just returns the same string it was 
passed.