Hi, Got the DA compiled yesterday, and now I'm having all kinds of trouble getting some semi-complex queries from my old perl scripts to work. Below is the response given by Zope to a good example: --- Error, exceptions.KeyError: unhandled SQL used: select i.name, c.language, c.notes, c.condition, c.bid, c.cardnum, i.rarity from cardinfo i, cards c where i.cardcode=c.cardcode order by i.name limit 10 Traceback (innermost last): File /usr/local/dc/Zope-2.0.0/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /usr/local/dc/Zope-2.0.0/lib/python/ZPublisher/Publish.py, line 179, in publish File /usr/local/dc/Zope-2.0.0/lib/python/Zope/__init__.py, line 201, in zpublisher_exception_hook (Object: test_listing) File /usr/local/dc/Zope-2.0.0/lib/python/ZPublisher/Publish.py, line 165, in publish File /usr/local/dc/Zope-2.0.0/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_test) File /usr/local/dc/Zope-2.0.0/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: manage_test) File /usr/local/dc/Zope-2.0.0/lib/python/Shared/DC/ZRDB/DA.py, line 316, in manage_test (Object: test_listing) File /usr/local/dc/Zope-2.0.0/lib/python/Shared/DC/ZRDB/DA.py, line 297, in manage_test (Object: test_listing) File /usr/local/dc/Zope-2.0.0/lib/python/Shared/DC/ZRDB/DA.py, line 401, in __call__ (Object: test_listing) File lib/python/Products/ZMySQLDA/db.py, line 191, in query KeyError: (see above) --- Simple, one-column queries seem to work fine. A search of the mailing list archives on "unhandled" didn't bring up much except one other person who'd had a similar problem and wasn't able to find an explanation. MySQL is version 3.21.33b and the query works fine when tested from the MySQL monitor. -->ben