[Zope] MySQLDA Problems with simple constant/function queries

[Stefan Franke]

I'm using MySQLDA 1.1.3 on Win32. When I type the following queries
into the test tab edit box, I get the traceback below:

  select LAST_INSERT_ID()

or

  select 1 from <table>


Of course "select * from <table>" works.

When I look into db.py, the error doesn't look very hard to fix, I think
I'll give tomorrow. Is there some API documentation of what a DA is
supposed to do?

Since the 1.1.4 query() code is identical, I think the problem appears
there as well.

Please reply to the posting via email directly, since I'm not subscribed
to the list.

Stefan
www.meso.net


-------------------------------

Error Type: KeyError
Error Value: unhandled

Traceback (innermost last):
  File D:\Programme\Zope2.2\mensa_m\lib\python\ZPublisher\Publish.py, line
224, in publish_module
  File D:\Programme\Zope2.2\mensa_m\lib\python\ZPublisher\Publish.py, line
189, in publish
  File D:\Programme\Zope2.2\mensa_m\lib\python\Zope\__init__.py, line 221,
in zpublisher_exception_hook
    (Object: RoleManager)
  File D:\Programme\Zope2.2\mensa_m\lib\python\ZPublisher\Publish.py, line
175, in publish
  File D:\Programme\Zope2.2\mensa_m\lib\python\ZPublisher\mapply.py, line
160, in mapply
    (Object: manage_test)
  File D:\Programme\Zope2.2\mensa_m\lib\python\ZPublisher\Publish.py, line
112, in call_object
    (Object: manage_test)
  File D:\Programme\Zope2.2\mensa_m\lib\python\Shared\DC\ZRDB\Connection.py,
line 178, in manage_test
    (Object: RoleManager)
  File D:\Programme\Zope2.2\mensa_m\lib\python\Products\ZMySQLDA\db.py, line
191, in query
KeyError: (see above)