Let queryParam do the work for you: UPDATE Soc SET TransProv = <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.TransProv#" null="#not len(form.TransProv)#" /> WHERE ID = <cfqueryparam cfsqltype="cf_sql_integer" value="100" />
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:332627 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
