I believe there is a JSStringFormat() function that escapes characters in a string for use in JavaScript.
Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 ************************************************************************ ************* Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] ************************************************************************ ************* -----Original Message----- From: Jason Miller [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 5:14 PM To: CF-Talk Subject: Single Quotes in Field value throwing error outputing in javascript on cf page Hello list - I have an access database - it already has text in a memo field riddled with ' quotes. Like - "Woman's" and "it's" and all sorts of words. Problem is it is creating an issue with my javascript event - which is onMouseOver="tip.show('#Trim(LinkDesc)#')" Do I need to do a replace function each time? Or do I have to run a filter on all existing fields and re-insert the info with a PreserveSingleQuotes? It throws cf errors on page rendered - it explains a mystery - "Expected )" issue. Also - it prevents any tip's from showing that have a single quote. I tested it to be sure this was the problem and in the mouseover - temporarily changed it to urlencodedformat and it fixed all issues.. but obviously for readability -that's not a solution. What's the best, quickest and easiest way to go here? Advice? I tried a few things but nothing worked for me 100% or was effective (not spaghetti) thanks! jay ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

