[Zope-DB] ZSQL, sum() and you
Mon, 3 Sep 2001 09:11:41 +0200
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...