Are you using <CFQUERYPARAM>? Ive seen instances where the MAXLENGTH attribute is different to the DB's and then gives this error regardless to the length of the string being passed into the tag/db
HTH -----Original Message----- From: Dan O'Keefe [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 15:40 To: CF-Talk Subject: RE: SQL - String or binary data would be truncated. No, IE. I don't think it is the browser, but MSSQL itself. I have never seen before where a CF submitted query not work consistently with the query submitted via ISQLW. Dan =================== Previous Message Below =================== -----Original Message----- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 10:13 AM To: CF-Talk Subject: Re: SQL - String or binary data would be truncated. Is a Mac IE browser giving the issue? - Calvin ----- Original Message ----- From: "Dan O'Keefe" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, June 26, 2003 10:05 AM 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
