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

Charlie Clark charlie@begeistert.org
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: 
> 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?

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.