Mailing List Archive: ZSQL, sum() and you

Mailing List Archive: Zope: DB
ZSQL, sum() and you

Index | Next | Previous | View Flat

mitchy at spacemonkeylabs

Sep 3, 2001, 12:11 AM

Views: 1200
Permalink

ZSQL, sum() and you

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
sick.

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

Subject	User	Time
ZSQL, sum() and you	mitchy at spacemonkeylabs	Sep 3, 2001, 12:11 AM
Re: ZSQL, sum() and you	fog at mixadlive	Sep 3, 2001, 12:27 AM
RE: ZSQL, sum() and you	mitchy at spacemonkeylabs	Sep 3, 2001, 12:43 AM
Re: ZSQL, sum() and you	matt at zope	Sep 3, 2001, 5:15 AM
Re: ZSQL, sum() and you	rhires at earthlink	Sep 3, 2001, 6:27 AM
RE: ZSQL, sum() and you	mitchy at spacemonkeylabs	Sep 3, 2001, 6:33 AM
Re: ZSQL, sum() and you	dieter at handshake	Sep 3, 2001, 3:36 PM
Re: ZSQL, sum() and you	tjenkins at devis	Sep 4, 2001, 5:38 AM

Index | Next | Previous | View Flat

Interested in having your list archived? Contact Gossamer Threads