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
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 )
Hello Peter, thank you. I'll give a look to the db.py file. The second option is a no way because when I have a query with a date field the whole select fail, I've no chance to access the fields. Sunday, March 04, 2001, 6:26:21 PM, you wrote: PB> I had the problem with TIME fields. PB> Somewhere at the top of db.py in /lib/python/Products/ZMySQLDA/ is a PB> dictionary of fields to be converted. You'll find you fieldtype there as PB> well. Comment it out from the conv dictionary. PB> Or try to solve the problem by enclosing the DateTime stuff in a try: - PB> except: clause. PB> Peter PB> ----- Original Message ----- PB> From: "Salvatore Sciacco" <sas@prometeus.net> PB> To: <zope@zope.org> PB> Sent: Saturday, March 03, 2001 4:09 PM PB> Subject: [Zope] MySQL, ZMYSQLDA and date fields
Hello,
I've a MySQL table with some datetime fields (not null). By default MYSQL PB> put '0000-00-00 00:00:00' (a zero date) in these field. When this happen I PB> 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 )
-- Best regards, Salvatore mailto:sas@prometeus.net
participants (2)
-
Peter Bengtsson -
Salvatore Sciacco