Re: [Zope] SQL-Query works with MySQL-monitor but not with ZMySQLDA

Hi Andy, Andy Pahne wrote:

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

Please try: SELECT YEAR(START_DATE) AS START_YEAR FROM EVENT in your query. (I hope MySQL supports renaming) The problem seems zope does not get a name for the calculated column.