[Zope] ZMySQLDA and aggregate functions on Win

Markus Kemmerling markus.kemmerling@mediaweb.at
Fri, 12 Jan 2001 03:25:24 +0100


I have a problem with ZMySQLDA and aggregate functions in combination with 
grouping on Windows.
When I say:
    SELECT COUNT(*) FROM mytable GROUP BY myfield;
I get an KeyError 'Unhandeld'.

    SELECT COUNT(*) FROM mytable;
works fine, so does
   SELECT myfield FROM mytable GROUP BY myfield;
but not the combination of both.
Also on a linux machine the error doesn't occur. Of course I tested the 
queries from the mysql command line.

Any help?

Markus Kemmerling