CF7 query update with single quote

[achab23]

Hi
i'm migrating an application from CF5 to CF7 (hotfix3) and have the following
problem:
the query
<cfquery...>
UPDATE t1
SET f1 = '#var1#'
</cfquery>

does not work fine when I have 2 single quote in var1 (let's say var1 = "''")
in the database (SQL server 2000 sp4) the above query insert 1 single quote
only
It seems to me a bug in escaping the single quote

any suggestion or workaround?

thanks
stefano

[achab23]

Hi
found the following fix in CF6.1 - but cannot apply the fix to CF7, of course

[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19108[/url]
ColdFusion MX 6.1: Hot fix for cfquery/cfqueryparam

Macromedia has created a hot fix to address the following issues with cfquery
and cfqueryparam in Macromedia ColdFusion MX 6.1:

53852 - When a string expression is evaluated inside a cfquery tag, each
single quote character is escaped to two single quotes. In certain cases, such
as when complex CFML expressions are evaluated in a cfquery tag especially
within a cfloop, the single quotes may be repeatedly escaped.

[raymacro]

Did you ever find a resolution to this problem in CF 7? I am running into the same issue. I found the 6.1 solution as well, but nothing for 7.

[Dan Bracuk]

Either preservesinglequotes or cfqueryparam should solve your problem.

[raymacro]

:D Worked like a charm. Thanks sooo much!

[cfdba]

Please let me know what exactly u did to get around this problem on 6.1 as well as 7 MX.
TIA