[Zope] Using SQL aggregate functions

John Williams J.A.R.Williams@aston.ac.uk
28 Feb 2000 08:17:42 +0000


I have been trying to use SQL aggregate functions in SQL Methods to
calculate some statistics e.g. something like

SELECT id,count(id) from data group by field

I am using MySQL, and the query works if entered directly from another
client, however Zopes SQL method returns an error. Is this a known
problem. Is there a known workaround or patch?

-- 
Dr. John A.R. Williams
Photonics Research Group
Telecommunications Technology Programme Director
Aston University