One of my table fields (and this occurs in many of my tables) is edited using CKEditor. This means the data will look like <p>text data </p>
I am using Access at the moment, converting to MySQL. I have not tried this with the MySQL database; it fails using the Access database. (But, I have a number of applications away from work which will continue using Access into the near future.) My code in an insert query (CF10) is <cfqueryparam value="#CovNote#" cfsqltype="cf_sql_longvarchar"> The error is "Application uses a value of the wrong type for the current operation." Take out the <p> </p> and it works fine, implying the paragraph tags are the problem. Take out the cfqueryparam (i.e., '#CovNote#') and it works fine. Any ideas? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354407 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm