it should do. <cfquery name="insert" database="Database"> Insert into Tablename ( Fieldname ) values ( <cfqueryparam cfsqltype="cf_sql_varchar" value="God's Kitchen 05">) </cfquery>
this should solve your problem. On 10/11/05, Andrew Scott <[EMAIL PROTECTED]> wrote: > Whether I have to or not it doesn't fix the problem. > > Regards, > Andrew Scott > > Quote of the Day: > The years teach much which the days never knew. - Ralph Waldo Emerson > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Robertson-Ravo, Neil (RX) > Sent: Thursday, 10 November 2005 6:40 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Single Quote Preservation > > You should be using cfqueryparam > > > > > > --- > 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/
