This is curious to me - I tried this on my Linux platform from mysql and it
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
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.
Zope maillist - [EMAIL PROTECTED]
** No cross posts or HTML encoding! **
(Related lists -