[Zope] ZMySQLDA and aggregate functions on Win

2001-01-12 Thread Dave Woolston
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

[Zope] ZMySQLDA and aggregate functions on Win

2001-01-11 Thread Markus Kemmerling
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;