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>