Hi Adam, I support Renee and Maureen,in their response to your post.
I would also add that you should get use to use the <cfqueryparam> tag in your query structures. Plenty of info online as to why (http://tutorial138.easycfm.com) for one. tbl_field = nullif(<cfqueryparam value="#form.???#" cfsqltype="cf_sql_varchar">,'') The above will insert null if the submitting variable is empty or will submit the variable that was actually entered. Can be used in either an update or insert query. Leonard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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-newbie/message.cfm/messageid:4983 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
