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: