>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>
Why are you using numberFormat() for your null attribute? It should be:
null="#yesNoFormat(NOT Len(trim(form.exp_years)))#"
(Remember to use NOT, otherwise your value for null will be the reverse of what you really want it to be.)
Regards,
Dave.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
