servesinglequotes doesn't work in this instance.
Hope this solves your problem
Bonnie
AGS
-Original Message-
From: Peter Theobald [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 28, 2000 10:55 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: SQL and apostrophes
--=_368
Just put it between double quotes. Most datatypes use
doublequotes anyhow..
so it would be
last_name="O'Brien" and you should be okay.
let me know if i'm retarded or not.. i probably am :-)
This actually breaks CFQuery - especially if you use the SQL parameter of
the tag
BTW, I've checked
he end of the string). :-(
At 04:18 PM 7/28/00 -0400, Jake Hileman wrote:
Just put it between double quotes. Most datatypes use doublequotes anyhow..
so it would be
last_name="O'Brien" and you should be okay.
let me know if i'm retarded or not.. i probably am :-)
jake
- Original Messa
Jake
- Original Message -
From: "Brian W. Zaleski, DC, MS" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, July 29, 2000 1:50 PM
Subject: Re: SQL and apostrophes
Jake,
I may be totally off base, but in ASP you do something like this:
Function RequestDQ (VarName)
Any SQL Server 7 gurus out there that know how to allow
apostrophe's in SQL
statements? For example, last_name = 'O'Brien' chokes the query.
Not a SQL Server problem, but a SQL problem
Use PreserveSingleQuotes() - it doubles the apostrophies for the SQL
Philip Arnold
ASP Multimedia
Use PreserveSingleQuotes() - it doubles the apostrophies for the SQL
I'm getting confused here. I didn't think that was what
PreserveSingleQuotes() does.
I thought this function was for *keeping* the quotes the way they were and
not escaping them.
E.g. if you have a dynamically-constructed
--=_12476792==_.ALT
Content-Type: text/plain; charset="us-ascii"
I'm having the same problem.
At 04:03 PM 7/27/00 -0600, Nick Call wrote:
Any SQL Server 7 gurus out there that know how to allow apostrophe's in SQL
statements? For example, last_name = 'O'Brien' chokes the
L PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, July 28, 2000 1:23 PM
Subject: Re: SQL and apostrophes
--=_12476792==_.ALT
Content-Type: text/plain; charset="us-ascii"
I'm having the same problem.
At 04:03 PM 7/27/00 -0600, Nick Call wrote:
Any SQL Server 7
OTECTED]
Sent: Friday, July 28, 2000 1:23 PM
Subject: Re: SQL and apostrophes
--=_12476792==_.ALT
Content-Type: text/plain; charset="us-ascii"
I'm having the same problem.
At 04:03 PM 7/27/00 -0600, Nick Call wrote:
Any SQL Server 7 gurus out there th
Any SQL Server 7 gurus out there that know how to allow
apostrophe's in SQL
statements? For example, last_name = 'O'Brien' chokes the query.
last_name = 'O''Brien'
By the way, CF does this automatically in cfquery:
cfset lname = "O'Brien"
cfquery
last_name = '#lname#'
...
/cfquery
10 matches
Mail list logo