cfqueryparam error

[Tim Laureska]

Can someone help me understand why I'm getting this error on the code
below:

ODBC Error Code = 22005 (Error in assignment)
[Microsoft][ODBC Microsoft Access Driver]Invalid character value for
cast specification (null)

<cfparam name="exp_years" default="">

<cfquery datasource="available" dbtype="odbc">
INSERT INTO positions (exp_years)

VALUES (<cfqueryparam cfsqltype="CF_SQL_NUMERIC"
value="#form.exp_years#" maxlength="2"
null="#numberFormat(Len(form.exp_years))#">)

</cfquery>

Thanks
Tim

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---