Someone is calling htmleditformat() on the insert... -dhs
-- Dean H. Saxe "A true conservationist is a person who knows that the world is not given by his fathers, but borrowed from his children." -- John James Audubon On May 15, 2010, at 10:01 AM, Frank Moorman wrote: > All, > > I was wondering if someone could help me track down a bug... > > I am using Coldfusion 7 with MySQL 5.1. Every query in the application is > using <CFQUERYPARAM> and I am not sure if this is important to this > particular issue, but Global Script Protection is enabled on the server. > > My problem is this, a user enters an ampersand into a form field. The field > gets stored in the database with "&" replacing every "&". > > When I read the data from the table for display to a web browser I output it > using HTMLEditFormat to produce standards compliant pages. However, this > takes the data and changes it to "&amp;" displaying "&" in the web > browser. > > I need to display "&" to the users without the "amp;" I know that I could > remove all of the HTMLEditFormats and that will work, but in my mind that is > not the problem and I would prefer to fix the real issue and not just the > symptom. I would like to get actual "&" 's on the table not "&". I also > thought of using triggers to stop the issue but to me that also is just > treating the symptom. > > Does anyone know what is actually causing this behavior so that I can > actually fix it at the source? > > Thanks, > Frank > > > ------------------------------------------------------------- > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by http://www.fusionlink.com > ------------------------------------------------------------- > > > ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------