What is the datatype and length of the column in the Access database? This sounds like a pretty standard data truncation problem.
-Cameron On Fri, Feb 8, 2013 at 2:41 PM, Stephens, Larry V <steph...@iu.edu> wrote: > This gets stranger and stranger. It doesn't appear to have anything to do > with the <p> tags. I've found all I have to do is remove some of the end of > the message and it works. I played with several iterations and finally took > off the last sentence and then it works okay. > > Why the last sentence? Beats me. I worked up a program to look at the > ASCII code of the entire string and everything fell into the 32 - 126 range > except for some 10 (LF) and 9 (TAB) chars, and they don't seem to be a > factor. No EOL shows up. > > I'm at a loss. > > > > > > On Fri, Feb 8, 2013 at 11:18 AM, Stephens, Larry V <steph...@iu.edu> > > wrote: > > > > > > > > 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:354417 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm