That totally depends on your DB setup.
If you have a column that does not allow NULL, then you have have send the
empty string ('') if there's no value. If you have SQL code that tests
Country IS NULL, then you may want to send NULL for that value in place of
the empty string.
Again, depending on the situation, you can handle it all through the query
param:
<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#transferData.country#"
null="#not len(transferData.country)#" />
That will auto-NULL any empty value ...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:323548
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
