What happens if you simply hardcode the keyword null into your insert query?
Possibly unrelated, but I notice you are passing a varchar datatype to a numeric field.
Usually the error occurs due to mismatch in datatype of db field and cfsqltype of cfqueryparam. Is "FORM.ExpirationYear " of type date?.
If so <cfqueryparam value="#FORM.ExpirationYear#" cfsqltype="CF_SQL_DATE" null="yes">)
"http://www.adobe.com/livedocs/coldfusion/6.1/htmldocs/tags-b20.htm" (have a look ).
Hope this will solve your issue
If you open this database in Access and go to design view for the table in question, and look at the definition for this field, what are the settings for "required" and "allow zero length"?
I fixed it. I had it all set properly, it was the hosting company and their settings not allowing it to happen.
Thank you all for all your input.