MySQL NULL date displays as 30-11-0002 :-(

Classic Servoy
1

Running Servoy 1.2(Ifinal) on Linux with Java 1.4, NULL dates in MySQL display as ‘30-11-0002’ - quite confusing! Bug?

Thanks,
Neale.

2

what type of field are you displaying that?
textfield? Calendar?

a quick test i did with the current 2.0 beta release didn’t show that problem.

3

The underlying field is a MySQL DATE field.
Servoy picks this up as DATETIME and the displayType is TEXT_FIELD.

But, the value in the DB was not NULL (it should have been, but that’s our problem) - it was ‘0000-00-00’ (I’m still not sure how that came to be).

It was displayed by Servoy as 30-11-0002.

Loading the underlying DB with NULL values where appropriate made this go away.

Thanks,
Neale.