[Zope] Zope 2 ODBC date errors

[Jay, Dylan]

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
>