[Zope-DB] ZSQL, sum() and you

Mitch Pirtle mitchy@spacemonkeylabs.com
Mon, 3 Sep 2001 09:11:41 +0200

Hi folks,

There's something I've been wanting to ask, but after lurking around
I've noticed I'm the only one with this problem.  That occasion usually
precedes an embarassing episode -;^>=

Imagine, if you will, a ZSQL method called dbGetEmp containing "select *
from emp"; and want to also retrieve sum(salary).  This is with tables
in MySQL.  For the life of me, I cannot find any summing features in
Zope - do I gotta do this in Python just to get a total on one column?

Sure, I can do it with two separate queries, but argh that's just plain

Apologies in advance for missing the obvious, as I know this is taken
care of somewhere...