[Zope-DB] Error Value: Invalid value, 0000-00-00, for ...

Frerichs, Thomas (CONS FIN) Thomas.Frerichs@gecapital.com
Wed, 26 Mar 2003 12:15:07 -0000


Hi all, 

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
solution yet. 
I use:
Zope 2.6.1 (binary release, python 2.1, win32-x86), python 2.1.3, win32; 
ZODBCDA-3.1.0b2-win32-py21;
MySQL 3.23.54-win and
MyODBC-3.51.06

Has anyone an idea how to explain Zope that a date '0000-00-00' is a NULL
value?

Thanks in advance
Thomas