Bigger rookie mistake is not using cfqueryparam. Adam Haskell http://cfrant.blogspot.com
On 11/1/07, Rick Sanders <[EMAIL PROTECTED]> wrote: > > Hi Andy, > > Thanks for your response. I can't believe I made the rookie mistake of not > using single quotes instead of double quotes in the expression! > > Kind regards, > > Rick Sanders > Canada: 902-401-7689 > USA: 919-799-9076 > Canada: www.webenergy.ca > USA: www.webenergyusa.com > > -----Original Message----- > From: Andy Matthews [mailto:[EMAIL PROTECTED] > Sent: November-01-07 10:46 AM > To: CF-Talk > Subject: RE: Replacing Strings > > use single quotes in your replace function (and you don't need REReplace > just FYI). > > REReplace('dill"s','"',"'","ALL") > > -----Original Message----- > From: Rick Sanders [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 01, 2007 7:47 AM > To: CF-Talk > Subject: Replacing Strings > > Hey list, > > > > I'm trying to replace a double quote in a text field to a single quote. > I've > tried using ReReplace, but it still crashes the Cold Fusion server. > > What I've done is this: > > <cfoutput>#REReplace("dill"s",""","'","ALL")#</cfoutput> > > > > See, users tend to like using double quotes in a text field which breaks > the > SQL query. How can i check if there's a double quote in a #form.textfield# > and remove it? > > > > Thanks in advance. > > > > Rick Sanders > > Webenergy > > Canada: 902-401-7689 > > USA: 919-799-9076 > > Canada: www.webenergy.ca > > USA: www.webenergyusa.com > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292475 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
