<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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331907 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
