[Zope-DB] ZSQL, sum() and you
Dieter Maurer
dieter@handshake.de
Tue, 4 Sep 2001 00:36:03 +0200 (CEST)
Mitch Pirtle writes:
> 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?
You should look at "dtml-in"s statistics variables, e.g.
at
<http://www.dieter.handshake.de/pyprojects/zope/book/chap3.html>
Dieter