> >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:332629 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
