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>
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Thursday, 10 November 2005 12:16 p.m. To: CFAussie Mailing List Subject: [cfaussie] Re: Single Quote Preservation Well its simple <cfquery name="insert" database="Database"> Insert into Tablename ( Fieldname ) values ( 'God's Kitchen 05' ) </cfquery> Can't get any simpler than that. 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: Blind people don't bungee jump. It scares the dog too much. ------------------------------------------------------------------------ ---- -------------------------- -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, 10 November 2005 10:15 AM To: CFAussie Mailing List Subject: [cfaussie] Re: Single Quote Preservation Hey Andrew, Code snippet? Cheers Rod > Anyone able to answer this one. > > > > I am currently running this version of CF MX 6,1,0,hf56580_611 > > > > The problem is that the query no longer preserves single quotes > anymore, yet the documentation says that it does. > > > > Now I though I would try to save the query into a string, and Try > #PreserveSingleQuote(SQL)# and it still will not work, anyone know of > a known issue here? > > > > > > 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: > We shall not flag or fail. We shall go on to the end. We shall fight > in France, we shall fight on the seas and the oceans, we shall fight > with growing confidence and growing strength in the air, we shall > defend our island, whatever the cost may be. We shall fight on the > beaches, we shall fight on the landing grounds, we shall fight in the > fields and in the streets, we shall fight in the hills; we shall never > surrender. - Sir Winston Leonard Spencer Churchill > ------------------------------------------------------------------------ ---- > -------------------------- > > > > --- > 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/ --- 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/ This email contains confidential information. If you are not the intended recipient of this email, please notify Straker Interactive and delete the email. You are not entitled to use it in any way. --- 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/
