Hi, there, if I use my mysq-monitor to execute the following query, everything works fine: SELECT YEAR(START_DATE) FROM EVENT; but it doesn't work via the ZMySQLDA!?! Here's the traceback: Error, exceptions.KeyError: unhandled Traceback (innermost last): File /zope/ttl/Zope-2.0.1-src/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /zope/ttl/Zope-2.0.1-src/lib/python/ZPublisher/Publish.py, line 179, in publish File /zope/ttl/Zope-2.0.1-src/lib/python/Zope/__init__.py, line 201, in zpublisher_exception_hook (Object: sql_get_years_unique) File /zope/ttl/Zope-2.0.1-src/lib/python/ZPublisher/Publish.py, line 165, in publish File /zope/ttl/Zope-2.0.1-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_test) File /zope/ttl/Zope-2.0.1-src/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: manage_test) File /zope/ttl/Zope-2.0.1-src/lib/python/Shared/DC/ZRDB/DA.py, line 316, in manage_test (Object: sql_get_years_unique) File /zope/ttl/Zope-2.0.1-src/lib/python/Shared/DC/ZRDB/DA.py, line 297, in manage_test (Object: sql_get_years_unique) File /zope/ttl/Zope-2.0.1-src/lib/python/Shared/DC/ZRDB/DA.py, line 401, in __call__ (Object: sql_get_years_unique) File /zope/ttl/Zope-2.0.1-src/lib/python/Products/ZMySQLDA/db.py, line 191, in query KeyError: (see above) Andy Pahne ap@net22 net22 GmbH Bad Meinberger Strasse 1 32760 Detmold Tel.: 05231 - 580 640