Escaping single quotes

[chebbi]

Hi Guys

I need the cf function to escape single quotes in my string. I used htmleditformat but that didnt help.

Iam pasting simple two line code for you guys which i used

<cfset test=&quot;test'test&quot;>
<cfoutput>
#HTMLEditFormat(test)#
</cfoutput> Badrinath Chebbi

http://www.bmchebbi.com

 

[Silvano]

PreserveSingleQuotes(variable)
Sylvano
dsylvano@hotmail.com

 

[chebbi]

WWebSpider, I want to escape single quotes in my string not preserve them. Badrinath Chebbi

http://www.bmchebbi.com

 

[webmigit]

#Replace(string,&quot;'&quot;,&quot;\'&quot;,&quot;ALL&quot# hope that helps

 

[Silvano]

Replace(string, &quot;''&quot;, &quot;&squo;&quot;, &quot;all&quot

ascii for single quote is 39 so you can try this also:

Replace(string, &quot;#Chr(39)#&quot;, &quot;&squo;&quot;, &quot;all&quot

you can also try to escape it with &rsquo; or &lsquo; (left ot right single quote); Sylvano
dsylvano@hotmail.com

 

[Silvano]

one more thing, while HTMLEditFormat() escapes <>&quot;& characters, XMLFormat() will escape <>&quot;& and ' characters so I guess you can try this one too.

Sylvano
dsylvano@hotmail.com