6 Replies Latest reply on Jan 14, 2009 8:52 AM by Kibbage.TEESO

    String or binary data would be truncated. Error

    Kibbage.TEESO Level 1
      Why am I getting this error? All I want to do is set a bit field in my MSSQL DB to either a 0 or a 1. The arguments in my cfc are defined as:

      <cfargument name="bitCurrYearID" type="boolean" required="yes">
      <cfargument name="bitNextYearID" type="boolean" required="yes">

      Error I receive:

      Error Executing Database Query.
      [Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.

      The error occurred in C:\ColdFusion8\wwwroot\TEESO\cfc\ptacfc.cfc: line 384
      Called from C:\ColdFusion8\wwwroot\TEESO\pvt\pta\eventadmin\default.cfm: line 23
      Called from C:\ColdFusion8\wwwroot\TEESO\cfc\ptacfc.cfc: line 384
      Called from C:\ColdFusion8\wwwroot\TEESO\pvt\pta\eventadmin\default.cfm: line 23

      382 : <cfstoredproc procedure="prEventsCreateNewYear" datasource="#Application.DB#">
      383 : <cfprocparam value="#Arguments.bitCurrYearID#" cfsqltype="CF_SQL_BIT" type="In" null="false">
      384 : <cfprocparam value="#Arguments.bitNextYearID#" cfsqltype="CF_SQL_BIT" type="In" null="false">
      385 : </cfstoredproc>
      386 :

      My Calling code is attached: