should have pointed out that in the code below, "","","" <<< that is a left quote, right quote and an escaped double qoute, all surrounded in qoutes. Just read my email and it didn't show up as I intended, problems with the left and right qoutes come about through copying and pasting from Word ect.
-----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: 15 April 2002 13:09 To: CF-Talk Subject: RE: quotes I haven't checked too much to see if this is what you want, but this takes out left, right and straight(?) double quotes and inserts the entity name for double quotes in to the database instead value="#trim(replacelist(form.var, "","","", "",",""))#" But....... a problem I came across comes up when you have this in the DB......... "Hello" and you try to display 14 characters, you end up with "Hello&qu in a prefilled textbox for example. A simpler way around this if you are only going to be pulling double qoutes from the DB is to use single quotes in the html code, this is the way you get around the problem using html. Another way, would be to check to see if the string you get from the DB contains a double qoute and change the value="" to value='' in the html code, or vice versa. The problem with these is that if both single and double qoutes are being pulled, then ya stuffed. I hope that made sense Ade Anyone with any better more fool proof ways of doing it?? -----Original Message----- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: 12 April 2002 23:07 To: CF-Talk Subject: quotes Dear All, I'm facing a problem and can't figure out the solution and would love anyones help. the situation is this: i have a form for users to fill, i take their entry and enter it in the database, then i take it and display it in a form so they can edit it. the problem is this: if uses enter double quotes my html gets mixed up and considers the users quote to be the end of the output value for the input field. Example: <form> <input type="text" value="myvalue"> </form> myvalue is a variable which is read from the DB and contains a double quote now if myvalue = this is a double quote " like this. the output html will look like this: <input type="text" value="this is a double quote " like this."> and the output like this: this is a double quote and that's it..cause it took the double quote as the end of the value field. now what do i do? how can i prevent that from happing? Thanks, ===== Heidi Belal www.code-corner.com ICQ# 32127109 A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... __________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
