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: [EMAIL PROTECTED] W: www.sitehand.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
