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/
