If anyone is interested the problem lied in the Macromedia JDBC Drivers V3.4
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: The essence of all jokes, of all comedy, seems to be an honest or well intended halfness; a non performance of that which is pretended to be performed, at the same time that one is giving loud pledges of performance. The balking of the intellect, is comedy and it announces itself in the pleasant spasms we call laughter. - Ralph Waldo Emerson ---------------------------------------------------------------------------- -------------------------- -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Thursday, 10 November 2005 10: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/
