> I just realized that either sql JDBC driver or CF automatically translates > symbols like < into HTML code of < 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