Originally Posted by DaWei

This is not definitive help, but I've had difficulties reconciling NULL values from time to time. If you try to store NULL into a MySQL column that doesn't accept NULL, you will store a zero or "". MySQL has an IFNULL (a, b) and an ISNULL function which you might use to constrain the value returned to your code. VB has IsNull (). You should probably use these kinds of tests as NULL (as well as NaN) is treated differently by many languages. Sorry I can't give you any truly solid solution. Incidentally, I think the date field being zero vs NULL was changed at some version level. Crap like that always helps, right?