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
-------------------------------------------------------------