Ravi, He can use an empty string '' if he does not want to use a NULL.
Your suggestion, to set the database to default to NULL would only apply if he was doing an INSERT. Now think about this What if the alert (in the database) was "Help Me" Now he is on his form, he deletes help me to be empty in the text field, and he wants this change to be reflected in the database. With what you are suggesting, it will remain "Help Me" if he wipes it out of the text field (or whatever he is using) since it would not update. Thanks! Robert Bailey Ravi Gehlot wrote: > Hello Robert, > > I mentioned that he set the value on the database side to default to > NULL so even if nothing is passed it defaults to NULL. It is also a good > practice to default the value to NULL since NULL has no value/spaces and > it is less likely to cause an error. > > Thanks, > Ravi Gehlot. > > > > Robert Bailey wrote: > >> But it seems like what he is doing is if the form value is blank, he >> wants to make the database value null, not skip processing. >> >> Thanks! >> Robert Bailey >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316932 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4