Thanks Scott.
I think it's a cfmx issue - I suspect the ISP has not installed updater-3,
am still checking.
One of the fixes in updater 3 is
"In Updater 2, ColdFusion did not properly handle escaped single quotes in
queries"
It's supposed to be a standard cf behaviour that single quotes are
automagically escaped by the cfquery tag.
e.g. CF will swap
'I don't like ASP.'
for
'I don''t like ASP.'
as part of the sql update.
Phil.
----- Original Message -----
From: "Scott Thornton" <[EMAIL PROTECTED]>
To: "CFAussie Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, June 27, 2003 12:55 PM
Subject: [cfaussie] Re: Single Quote insert into SQL
> Hi Phil,
>
> The MS SQL database option:
>
> SET QUOTED_IDENTIFIER { ON | OFF}
>
> may be different on each server.
>
> This setting may be changed to either on or off for a particlar database.
> This will allow the string '"A string with quotes and double quotes'''"'
> to be entered and saved as "A string with double quotes'''" within the
> database.
>
> ---
> You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to
[EMAIL PROTECTED]
>
> MX Downunder AsiaPac DevCon - http://mxdu.com/
>
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
