I'm not sure what to do a search on this subject so please excuse me if this question was already asked.
I have a form. It has an optional field. When I go to insert a new record into the Oracle DB, the db will throw an error if the formfield is empty. I can get around this by using a <cfif len(trim(form.fieldname)>. Is there a better way to handle this? Isn't there a performance hit for this sort of quasi-dymanic sql statement? The only thing I can think off the top of my head is when I convert it to a stored procedure to check for the length there since quasi-dynamic queries have less impact on the DB side. TIA, W ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:329548 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4