Not to sound dumb my Florida friend, did you check the maxlengths of your form fields?
-----Original Message----- From: Dan O'Keefe [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 9:06 AM To: CF-Talk Subject: SQL - String or binary data would be truncated. Any one ever see this error in the browser, then copy and past the same query in ISQLW and it works fine for an insert. Does not make sense and I am baffled. I have checked the field types and lengths so many times now I remember them all. The only thing I can think of is one of the strings might have some type of control character in it. I wonder if it might be a log issue. Dan ------------ Dan O'Keefe 954-501-3115 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
