[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