[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