How to stop auto translation?
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 ...
...}
/textarea
/form
The data saved into a sql database table would looke like
some text lt;img src=userImage.gif ...gt;
But that's not desirable, I don't want the translation. How? Or am I missing
something real simple here?
Thanks.
Don
Chunshen Li
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319056
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to stop auto translation?
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 data immediately prior to inserting it into the database and see what it looks like then. Also, how are you looking at the data to confirm how it was saved? Tags like cfdump escape any html in the data for display purposes. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319059 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to stop auto translation?
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 data immediately prior to inserting it into the database and see what it looks like then. Also, how are you looking at the data to confirm how it was saved? Tags like cfdump escape any html in the data for display purposes. ~Brad Brad, good thought, thank you. Probably the iframe is the culprit (the above example wasn't accurate), then, I'm wondering if there's some regExp to convert all HTML code back to its orginial form. Don ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319064 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to stop auto translation?
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 data immediately prior to inserting it into the database and see what it looks like then. Also, how are you looking at the data to confirm how it was saved? Tags like cfdump escape any html in the data for display purposes. ~Brad Brad, good thought, thank you. Probably the iframe is the culprit (the above example wasn't accurate), then, I'm wondering if there's some regExp to convert all HTML code back to its orginial form. Don There is XMLUnformat it will probably do most of it: http:// cflib.org/index.cfm?event=page.udfbyidudfid=800 Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319065 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to stop auto translation?
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 would focus on finding out how/where it is getting that way in the first place. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319067 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to stop auto translation?
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? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319068 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to stop auto translation?
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 would focus on finding out how/where it is getting that way in the first place. ~Brad It looks like it's the iframe and wysiwyg stuff... I appreciate it. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319069 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
