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.
_______________________________________________
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )