[Zope] MySQL, ZMYSQLDA and date fields

[Peter Bengtsson]

I had the problem with TIME fields.
Somewhere at the top of db.py in /lib/python/Products/ZMySQLDA/ is a
dictionary of fields to be converted. You'll find you fieldtype there as
well. Comment it out from the conv dictionary.
Or try to solve the problem by enclosing the DateTime stuff in a try: -
except: clause.

Peter

----- Original Message -----
From: "Salvatore Sciacco" <sas@prometeus.net>
To: <zope@zope.org>
Sent: Saturday, March 03, 2001 4:09 PM
Subject: [Zope] MySQL, ZMYSQLDA and date fields


> Hello,
>
> I've a MySQL table with some datetime fields (not null). By default MYSQL
put
> '0000-00-00 00:00:00' (a zero date) in these field. When this happen I
can't
> select these fields anymore because Zope raise an invalid date format
> exception.
>
> Do you know a workaround for this problem?
>
> Thank you.
>
> --
> Best regards,
>  Salvatore Sciacco                          mailto:sas@prometeus.net
>
>
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )