<cfqueryparam cfsqltype="cf_sql_integer" value="#myValue#" null="#not
isNumeric(myValue)#" />
On 3/19/2010 4:45 PM, Frank Liu wrote:
> Hello,
>
> In my table, I have several fields with numberic data type.
> After the form is submitted, I found out zero are inserted into those fields
in the table if those fields are left blank in the form. However, I want null
value in my table. Please help.
>
> Thanks
>
>
