Mike, I wouldn't trust the line number of the error. In my experience, ColdFusion often reports a line number equal to one or two lines above </cfquery>.
ColdFusion just compiles some SQL and sends it to SQL Server. Since SQL Server doesn't specify which field is causing the problem, ColdFusion doesn't know either. Short answer, check your other fields for problems as well. You might try using the maxlength attribute of cfqueryparam. <plug> I have a free (and open source) DataMgr component that makes inserts and updates easier (less code, among other things). It also tells you which field is too long in the error. http://www.bryantwebconsulting.com/cfcs/ A version coming out (hopefully) this week will also optionally allow you to truncate incoming data to the length of the database field to avoid those errors. It currently supports MS SQL Server, MS Access, MySQL, PostGreSQL. Very easy to add others. </plug> Hope that helps! Steve Bryant. Bryant Web Consulting LLC http://www.BryantWebConsulting.com/ http://steve.coldfusionjournal.com/ >The error I am getting is... > >[Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data >would be truncated. It is highlighting > ><cfqueryparam cfsqltype="cf_sql_bit" value="#arguments.updates#"> ?? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224139 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
