> Just FYI, I tested it out a number of times and 5" updated > about 5 times still produced 5" (viewing source it was 5") > > I actually tested > & # too ... and it seemed to work just > fine as well -- Interesting. > > I guess back to my original question, should I htmleditformat > all my textareas and text fields that could possibly have these > types of characters?
Okay, so it doesn't double them up ... that's good to know. :) So the remaining question is : will you ever used the data in anything other than an html format output, i.e. plain-text email, pdf, tab-delimited data export, etc... If so, then you probably don't want to htmleditformat before you update the db. If you do know with certainty that it won't ever be used for anything else, then I'd say prior to going into the db is the best time to do it, since it cuts down if however slightly on the amount of work the server has to do later when it displays, which happens much more frequently than modifying data. Isaac www.turnkey.to 954-776-0046 ______________________________________________________________________ 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
