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/
