Thank you Dave for your answer. But what do you mean by you don't expect a SELECT returning a number to work? The error you got clearly is a mysql syntax error: If I have a table 'shop' and make a SELECT on 'show' I really wouldn't expect that to work ;-) But I don't get any mysql error, I get a python error. Let me repeat my problem and try to be a little bit more precise (I use your example): SELECT COUNT(*) FROM show GROUP BY article; works from the mysql command line, works from within Zope on linux, but breaks from within zope on windows. SELECT COUNT(*) FROM show; works from within Zope on windows, too. So the problem is to have a SELECT with COUNT() and GROUP BY-clause from within Zope on Windows. Since it works on the mysql command line, it is definitely not an SQL error. I use Zope 2.2.4, mysql 3.23gamma, ZMySQLDA 1.1.3 and the libmySQL.dll linked from the HowTo explaining the installation of ZMySQLDA on Win32. The error I get is of type 'KeyError' with value 'unhandeld' and occurs on line 191 of ZMySQLDA's db.py. This and the next lines read as follows: for d in desc: item={'name': d[0], 'type': defs[d[2]], 'width': d[3], } func(item) where 'desc' is the fieldlist of the result set returnded by the query and 'defs' is some kind of type-mapping defined at the top of db.py, that I don't really understand: defs={ "short": "i", "long": "i", "char": "s", "double": "n", "decimal": "n", "float": "n", "tiny blob": "t", "medium blob": "t", "long blob": "t", "blob": "t", "date": "d", "time": "s", "datetime": "d", "timestamp": "d", "varchar": "t", "string": "t", } The following little ugly hack makes my query work: for d in desc: try: item={'name': d[0], 'type': defs[d[2]], 'width': d[3], } func(item) except KeyError: item={'name': d[0], 'type': 'i', 'width': d[3], } func(item) So it seems to me that COUNT returns some field-type unknown to 'defs'. (What still confuses me is, that this only happens in combination with a GROUP BY-clause.) I wonder what's the value of d[2] for the COUNT()-column, but since I am quite new to python and Zope I still don't know how to debug. I also wonder if anybody running Zope with mysql on windows can reproduce this error. Or maybe someone with a good knowledge of ZMySQLDA and the python mysql-module has some hint? Sorry that this message got so long ... Markus Kemmerling > This is curious to me - I tried this on my Linux platform from > mysql and it > doesn't work. > Perhaps I misunderstand what you are trying to do: > > SELECT COUNT(*) FROM mytable - returns a number - so I really don't expect > it to work. > > I have a table - shop and a column in that table - article: > > mysql> select count(*) from show group by article; > ERROR 1064: You have an error in your SQL syntax near 'show group by > article' at line 1 > > Sorry if I misunderstand what you are trying to do - > > ================================= > Dave Woolston [EMAIL PROTECTED] > Digital Creations www.digicool.com > (716) 262-4715 > > > > 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 > > _______________________________________________ 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 )