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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292467
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
