[Zope-DB] Error Value: Invalid value, 0000-00-00, for ...
Frerichs, Thomas (CONS FIN)
Wed, 26 Mar 2003 12:15:07 -0000
I try to select some data out of a MySQL database which contains a column
suspension_date of type date.
Now when suspension_date is NULL the retrieved data for that column is
'0000-00-00'. This raises the following error in Zope:
Error Type: ValueError
Error Value: Invalid value, 0000-00-00, for suspension_date in record 0
I didn't found any information how to work around this problem. I found a
similar problem description in a German mailing list but nobody sent a
Zope 2.6.1 (binary release, python 2.1, win32-x86), python 2.1.3, win32;
MySQL 3.23.54-win and
Has anyone an idea how to explain Zope that a date '0000-00-00' is a NULL
Thanks in advance