PreserveSingleQuotes Not Working in CFQUERY

[MrBoston]

Just a heads up to those for those using CFSCRIPT within a CFQUERY to compose a
Dynamic SQL statement. When you try to use PreserveSingleQuotes(SQLTEXT) the
resulting query string is only partially escaped. The only Sucessfull approach
I found was to compose the SQL using CFSCRIPT outside of the query, and then
use PreserveSingleQuotes() within the CFQUERY block.

Hopefully this might save someone else the headache.

[david_h]

What version of CF are you using?
this is something we ran into. They broke the whole escaping thing with the
6.1 updater, and now refuse to fix it.

We actually store the SQL in our database and execute it later for logging
purposes and what not. When we read the data back from the db and try and
exceute in in a CFquery, it blows up because all of the single quotes, where
they were 1 or 2 are replaced with 2

[MrBoston]

I'm using ColdFusion MX 7.