How to stop auto translation?

2009-02-08 Thread Don L
Hi there, I just realized that either sql JDBC driver or CF automatically translates symbols like into HTML code of lt; prior to saving the data into a database table. Here's a case, a form looks like this form ... textarea ... {user input include some text img src=userImage.gif ... ...}

Re: How to stop auto translation?

2009-02-08 Thread Brad Wood
I just realized that either sql JDBC driver or CF automatically translates symbols like into HTML code of lt; prior to saving the data into a database table. I've never seen CF or JDBC do this. If your HTML is being escaped, I would look for a stray htmleditformat function. Dump out the

Re: How to stop auto translation?

2009-02-08 Thread Don L
I just realized that either sql JDBC driver or CF automatically translates symbols like into HTML code of lt; prior to saving the data into a database table. I've never seen CF or JDBC do this. If your HTML is being escaped, I would look for a stray htmleditformat function. Dump out the

Re: How to stop auto translation?

2009-02-08 Thread Paul Kukiel
I just realized that either sql JDBC driver or CF automatically translates symbols like into HTML code of lt; prior to saving the data into a database table. I've never seen CF or JDBC do this. If your HTML is being escaped, I would look for a stray htmleditformat function. Dump

Re: How to stop auto translation?

2009-02-08 Thread Brad Wood
I'm wondering if there's some regExp to convert all HTML code back to its orginial form. I'm sure there could be if you wanted. You've only got four characters to put back according to the docs: lt; gt; amp; quot; If your goal is to not have the HTML escaped in the first place, I

Re: How to stop auto translation?

2009-02-08 Thread Don L
I just realized that either sql JDBC driver or CF automatically There is XMLUnformat it will probably do most of it: http:// cflib.org/index.cfm?event=page.udfbyidudfid=800 Paul Thanks for the idea, Paul, but it may be overkill?

Re: How to stop auto translation?

2009-02-08 Thread Don L
I'm wondering if there's some regExp to convert all HTML code back to its orginial form. I'm sure there could be if you wanted. You've only got four characters to put back according to the docs: lt; gt; amp; quot; If your goal is to not have the HTML escaped in the first place, I