And, FWIW, converting it to base 64 doesn't get rid of whatever cfqueryparam is choking on. This is in the cfqueryparam tag as an insert without it works fine.
-----Original Message----- From: Stephens, Larry V [mailto:steph...@iu.edu] Sent: Friday, February 08, 2013 2:41 PM To: cf-talk Subject: RE: cfqueryparam issue 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:354418 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
