<cfquery name="insert" database="Database"> Insert into Tablename ( Fieldname ) values ( 'God''s Kitchen 05' ) </cfquery>
OR <cfset valText="God's Kitchen 05"> <cfquery name="insert" database="Database"> Insert into Tablename ( Fieldname ) values ( #PreserveSingleQuotes(valText)#) </cfquery> Do either of these options work? hth Rod > > 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/ > --- 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/
