> <cfqueryparam > cfsqltype="cf_sql_integer" > value="#ARGUMENTS.FieldFmtTypeID#" > null="#Len(Trim(ARGUMENTS.FieldFmtTypeID))#"/>,
Do you not mean: .... null="#NOT Len(Trim(ARGUMENTS.FieldFmtTypeID))#"/> ie Insert null when the value IS an empty string -Leigh ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:328318 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4