I have a page that posts form data via cfhttp post and then receives a comma separated list of response values. I control both the remote posting code and the code that generates the response.
Everything is working perfectly except the first entry of the comma separated value list is reporting a length of 508 characters, even though it's only displaying a single character, which is a result code (only possible values are 1, 2 or 3). So it displays properly as a 1, 2 or 3, but when I try to insert it into a database, it says the value is too long. I tried TRIM and it has no effect. Through experimentation I've figured out I can use the RIGHT(x,1) function (where x is my variable) as a workaround, but every single transaction has over 500 characters of extra data that I can't seem to remove, or even see. Oddly, if I use LEFT(x,1) I get a "<" which leads me to believe there is some sort of hidden code, but if I use LEFT(x,2) or greater, all the way to 507, I don't see anything (not even the leading "<"). Very strange. I've verified that the responding page is not generating the extra data, I even added the the original LEN value as an additional field in the comma separated list and it is showing properly as 1. So I have to believe that somehow the local cfhttp post is appending the mystery content to cfhttp.filecontent. Anyone ever seen this before? And more importantly, of course, know how to fix it? Thanks, Mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327414 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
