Pascal Peters wrote:
This is intended behavior: any CF string variable within a cfquery
will escape (double) single quotes. I think it has always been like this
(at least since CF4).
OK, thanks for clearing that up.
This would throw an error if single quotes weren't escaped. This is
purely
isn't that the common thing that PreserveSingleQuotes() is used for?
Doug
- Original Message -
From: Damien McKenna [EMAIL PROTECTED]
Date: Fri, 17 Sep 2004 16:54:06 -0400
Subject: cfquery still breaking apostrophies in CFMX 6.1 updater?
To: CF-Talk [EMAIL PROTECTED]
I've just noticed
with the
PreserveSingleQuotes() function.
Pascal
-Original Message-
From: Damien McKenna [mailto:[EMAIL PROTECTED]
Sent: 17 September 2004 22:54
To: CF-Talk
Subject: [Spam?] cfquery still breaking apostrophies in CFMX 6.1
updater?
I've just noticed that the CFQUERY fix for apostrophies from the CFMX
6.1
I've just noticed that the CFQUERY fix for apostrophies from the CFMX
6.1 updater may not be fixed.I've got a query that does something
along the line of SELECT * FROM table_blah WHERE #from# #equal# #to#
where the #to# comes from SQL Server is something along the lines of
('N', 'n').However
-Original Message-
From: Phil Arnold [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 04, 2000 5:49 AM
To: [EMAIL PROTECTED]
Subject: RE: apostrophies troubles
Are you using PreserveSingleQuotes() on the string?
Yes, here's the query:
These let the single quotes into the database
Are you using PreserveSingleQuotes() on the string?
Yes, here's the query:
These let the single quotes into the databasewithout these the insert
errors out.
cfset vdescription=Replace(#strDESCRIPTION#, "'", "''", "ALL")
cfset veducation=Replace(#strEDUCATION#, "'", "''", "ALL")
Has anyone else had problems getting query insert statements to work with
apostrophies in the text? I've had the problem on two different occasions
even with putting a preservesinglequote around the offending field. I've
finally just did a replacenocase on the apostrophies.
I'm running CF
Has anyone else had problems getting query insert statements to work with
apostrophies in the text? I've had the problem on two different occasions
even with putting a preservesinglequote around the offending field. I've
finally just did a replacenocase on the apostrophies.
I'm running CF
Does anyone else have trouble with apostrophies when submitting fields to an
access2000 database?
I've put preservesinglequotes around the fields and that didn't stop the
problem, so I had to wind up doing a replacenocase and put the ascii
equivalent to get around it. It's getting to be quite
9 matches
Mail list logo
