Robert,
You are right. If you default the value to NULL on the database,
NULL only comes into play when you first create a record. So you are
correct when you say that he can pass an empty string and it will be
empty and not NULL on the database. What you are saying is that the
query should run anyways because might want to just wipe out what he has
on the database opposed to inserting some other string or number. With
the code I had before, he would only run the query if he had value
length which makes it impossible to update it with an empty value.
Good Thought,
Ravi Gehlot.
Robert Bailey wrote:
> 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
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:316935
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
