cfstoredproc question

[Schreck, Tom]

I have a stored procedure to update data in a table.  Some of the fields I'm passing in can be null.  My stored proc is bombing on null fields.  I get the message "Invalid character value for cast specification"

Here's my stored proc call:
        <cfstoredproc procedure="sp_actUpdateTaxonomyTypeMapping" datasource="#Request.DSN#">
                <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" variable="numSiteID" value="#Request.stAttributes.numSiteID#" null="No">
                <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" variable="numTaxonomyTypeID" value="#Request.stAttributes.numTaxonomyTypeID#" null="No">
                <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" variable="numTaxonomyID" value="#loopItem#" null="No">
                <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" variable="numOrder" value="#iterativeOrder#" null="No">
                <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" variable="txtDefaultFuse" value="#variables.txtDefaultFuse#" null="no">
                <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" variable="txtImageExtension" value="#variables.txtImageExtension#" null="no">
                <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" variable="txtImageKey" value="#variables.txtImageKey#" null="no">
                <cfprocparam type="In" cfsqltype="CF_SQL_TINYINT" variable="numImageWidth" value="#variables.numImageWidth#" null="no">
                <cfprocparam type="In" cfsqltype="CF_SQL_TINYINT" variable="numImageHeight" value="#variables.numImageHeight#" null="no">
                <cfprocparam type="In" cfsqltype="CF_SQL_BIT" variable="ynIsDefault" value="#variables.ynDefaultTaxonomy#" null="No">
                <cfprocparam type="In" cfsqltype="CF_SQL_BIT" variable="ynIsActive" value="#Evaluate('Request.stAttributes.ynIsActive_#loopItem#')#" null="No">
        </cfstoredproc>

 

 

Thanks - Tom