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
