[Zope-DB] Error Value: Invalid value, 0000-00-00, for ...
Wed, 26 Mar 2003 13:26:34 +0100
On 2003-03-26 at 13:15:07 [+0100], Frerichs, Thomas (CONS FIN) wrote:
> 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:
> 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;
> MySQL 3.23.54-win and
> Has anyone an idea how to explain Zope that a date '0000-00-00' is a NULL
No, but you might want to try using the mxODBC driver and DA as it looks
like ZODBCDA / MyODBC are not working properly. I've had no problems with
NULL dates in MySQL when using the Python MySQL driver.