-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Jochem van Dieten wrote:
> On re-reading that was very poorly worded by me. > > The SQL DEFAULT keyword is not just meant for use in DDL. SQL is > defined in such a way that you can also use DEFAULT in DML to > (re)set any column to its default value. You don't even have to > know what that default is. So in SQL you can use the command > "UPDATE subscribers SET title = DEFAULT" to restore the default > value for the title field in the subscribers table. > > More complete implementations already have your better solution. Yeah, and did I not point out that something like that would be a better solution? If you go back and read what I wrote after the bit you snipped again, you'll see that all I was doing was offering reason why they would have chosen to use that NULL hack rather than doing things neatly. K. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCnutrmSWF0pzlQ04RAg0aAJ90SP3iSt9uTaaxl53aTejhmsyF9QCgsLc4 e70uurHEEQ2ybk446SBOrkI= =wOi0 -----END PGP SIGNATURE----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208334 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54