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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292470 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4