Its that damm timezone problem in zope. If the python string returned as your timezone is not known to zope it barfs. This problem has been going on for months and I feel because it is something that only effects non-american zope users there has not been enough effort into fixing it. In fact I have fixed this bug and submitted it and am disappointed that it has not made into the source yet as was promised. This is a show stopping bug. In certain countries any application that uses dates from sql where a timezone is not supplied is going to crash!!! Please stop being so US centric and fix this bug!!!

-----Original Message----- From: Graham Chiu [mailto:anon_emouse@hotmail.com] Sent: Sunday, July 25, 1999 10:28 To: zope@zope.org Subject: [Zope] Zope 2 ODBC date errors

I've installed the Win32 2.0.0b1, and now find that *all* my Zsql queries where dates are returned using the ODBC adapter, now fail.

Here is a traceback from a test

<!-- Traceback (innermost last): File F:\Zope2\lib\python\ZPublisher\Publish.py, line 256, in publish_module File F:\Zope2\lib\python\ZPublisher\Publish.py, line 161, in publish File F:\Zope2\lib\python\ZPublisher\mapply.py, line 154, in mapply (Object: manage_test) File F:\Zope2\lib\python\ZPublisher\Publish.py, line 98, in call_object (Object: manage_test) File F:\Zope2\lib\python\Shared\DC\ZRDB\DA.py, line 307, in manage_test (Object: sqlShowBasketDescription) File F:\Zope2\lib\python\DocumentTemplate\DT_String.py, line 502, in __call__ (Object: <string>) File F:\Zope2\lib\python\DocumentTemplate\DT_In.py, line 591, in renderwb (Object: sqlShowBasketDescription) File F:\Zope2\lib\python\Shared\DC\ZRDB\RDB.py, line 272, in __getitem__ ValueError: Invalid value, 1999-07-19 21:34:50, for LDATE in record 0

------- Regards, Graham Chiu gchiu<at>compkarori.co.nz