Re: MS SQL - Syntax error for valid query

[Ian Skinner <iskinner@xxxxxxxxxxx>]

AWFrueh1808 wrote:
> Thinking about this some more...I know what preservesinglequotes does - it 
> retains single quotes in a variable by keeping them from being parsed by CF.

I don't think you have quite the right handle on preserveSingleQuotes(). 
 It's only purpose is for use in SQL statements.  Let's look at a 
literal example.

INSERT INTO aTable
(aField)
'Let's go to the park at 10 o'clock, can't we?'

This statement would fail because of the single quotes in the data one 
needs to preserve these by escaping them.

INSERT INTO aTable
(aField)
'Let''s go to the park at 10 o''clock, can''t we?'

This is the default behavior for variables inside of a SQL statement. 
CF will escape single quotes under the assumption that you want them 
inserted into the database as data.

<CFSET text = "Let's go to the park at 10 o'clock, can't we?">

INSERT INTO aTable
(aField)
#text#

The preserveSingleQuotes() function is the switch when one does NOT want 
the single quotes escaped inside of a SQL statement.