why do you need to remove them in the first place? Take a look at JSStringFormat() for display layer and use cfqueryparm for DB layer. DK
On 5/12/05, jgeorges <[EMAIL PROTECTED]> wrote: > > When the text is submitted from a form with an INPUT statement (text box) > the following code works: > > <cfset newtext = #replace(oldtext, '"', "'", "ALL")#> > > When the text is submitted from a form with a TEXTAREA statement the > following code works: > > > <cfset squote = "´"> > > <cfset dquote = """> > > <cfset newtext = #replace(oldtext, dquote, squote, "ALL")#> > > Note, I am trying to eliminate double quotes. 'squote' is actually the > acute symbol. It will not work with a single quote. > > Thanks, > > Sam > > ----------------------------------------------- > > ...... > > <cfset squote = "´"> > > <cfset dquote = """> > > <cfset newtext = #replace(origtext, dquote, squote, "ALL")#> > > ...... > > origtext contains double quotes (") which the REPLACE function does not > convert. > > ------------------------------------------------- > > _______________________________________________ > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206558 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54