[Zope] ZSQL error using MySQLDA

Rick Ree Rick Ree <rree@oeb.harvard.edu>
Wed, 1 Sep 1999 16:19:07 -0400 (EDT)


I have a MySQL query as follows:

select foo.id, bar.name, count(*)
from foo, bar
where (foo.id = bar.id)
group by foo.id

This query executes normally from the mysql client, and I get:

id	name	count(*)
1	joe	10
2	blow	24
etc...

When implemented as a Z SQL Method, I get the message:

Error, exceptions.KeyError: unhandled

Why might this be?  If I omit count(*) from the query it runs fine, or if
I use count(*) in a query involving only a single table, it also works. 

I'm running Zope 2 beta6, Linux (RH5.2), and MySQL 3.22.19

TIA for help,

Rick