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

[Tino Wildenhain]

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.