MX7 Double Quote

[Ebeneezer]

I just upgraded to MX7.

CFQUERY using where x = "sam" used to work & now the double quotes are being
treated as escape characters. I don't want to have to change all of the double
quotes to single quotes in the SQL statements throughout my project.

Any help would be appreciated.

[ToeJam]

Use cfqueryparam for security and you won't need the quotes anymore unless it
is part of your data.

WHERE COLName = <cfqueryparam value = "sam" cfsqltype = "varchar">

See the docs for all the options incuding using lists!

[ToeJam]

You may also be able to use PreserveSingleQuotes as copied from help file
example:

<cfquery name = "GetCenters" datasource = "cfsnippets">
SELECT Name, Address1, Address2, City, Phone
FROM Centers
WHERE City IN (#PreserveSingleQuotes(List)#)
</cfquery>

[Ebeneezer]

Thanks for the suggestions. I'm looking for a setting probably for the driver
that will allow the java engine and/or the database to handle double quotes in
SQL statements. It worked in CF5 so there must be some way to do it in MX.