Re: Single Quote Preservation

Andrew

Have you tried using <cfqueryparam>

<cfquery name="insert" database="Database">  Insert into Tablename  (
Fieldname ) values ( <cfqueryparam value="God's Kitchen 05"> ) </cfquery>

Regards
Daniel Crowther

 

Chief Information Officer
M: 0412 931 398
E: daniel@...
W: www.sitehand.com


-----Original Message-----
From: bounce-cfaussie-21282@...
[mailto:bounce-cfaussie-21282@...] On Behalf Of Andrew Scott
Sent: Thursday, 10 November 2005 9:23 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Single Quote Preservation

David,

I did say that under CFMX the preserve single quotes according to the
documentation preserves single quotes!!

And I did also say that I have tried PreserveSingleQuotes I believe I did, I
think yes I did actually!!


Regards
Andrew Scott
Analyst Programmer

CMS Transport Systems
Level 2/33 Bank Street
South Melbourne, Victoria, 3205

Phone: 03 9699 7988  -  Fax: 03 9699 7976

Quote:
"Space...is big. Really big. You just won't believe how vastly hugely
mindbogglingly big it is. I mean you may think it's a long way down the road
to the chemist, but that's just peanuts to space. "  Douglas Adams
----------------------------------------------------------------------------
--------------------------
-----Original Message-----
From: bounce-cfaussie-12196@...
[mailto:bounce-cfaussie-12196@...] On Behalf Of David Harris
Sent: Thursday, 10 November 2005 10:25 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Single Quote Preservation

Won't it get confused with the quote in God's?

Try
<cfquery name="insert" database="Database">  Insert into Tablename  (
Fieldname ) values ( 'Gods Kitchen 05' ) </cfquery>



---
You are currently subscribed to cfaussie as: daniel.crowther@... To
unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/



---
You are currently subscribed to cfaussie as: lists@...
To unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/