You may receive this error when attempting to insert an empty string into a numeric database column. This logic should provide a good example on how to handle this situation:

<cfif isDefined("arguments.version")>
    <cfif trim(arguments.version) neq "">
        version = <cfqueryparam value="#arguments.version#">,
    <cfelse>
        version = <cfqueryparam null="true">,                       
    </cfif>
</cfif>

Leave a Reply

Your email address will not be published. Required fields are marked *