Good point Isaac. Ron
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of S.Isaac Dealey Sent: Monday, January 05, 2004 12:16 PM To: [EMAIL PROTECTED] Subject: Re: Replace double quotes with single quotes That may not actually be a double-quote, but rather two single-quotes. This happens occasionally when using the (very poor) Merant drivers for Oracle databases (which ship with CF) when inserting or updating data with the (best practice) cfqueryparam tag. I've not yet seen it happen with any MS databases or with the drivers from Oracle, though I wouldn't be surprised to see it happen with Merant or other poor 3rd party drivers for other databases. The other alternative of course is to remove cfqueryparam from the code, which may be your only option if you don't have access to the CF Admin to change the drivers. Imho better drivers is the best solution. > Hi All, > I have text that is showing with double quotes like so: > Ron"s > How do I replace all of the double quotes with single quotes in CF? > Thanks in advance! > Ron s. isaac dealey 214-823-9345 team macromedia volunteer http://www.macromedia.com/go/team chief architect, tapestry cms http://products.turnkey.to onTap is open source http://www.turnkey.to/ontap ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
