Yes, I compared the lengths. This is queried from one table and then inserted into another. The table it is coming from originated from a text file that CF inserted. I found one issue so far that a certain field had a single quote in it, so I am escaping those now on the text to SQL import.
Dan =================== Previous Message Below =================== -----Original Message----- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 10:07 AM To: CF-Talk Subject: RE: SQL - String or binary data would be truncated. 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
