mitchy at spacemonkeylabs
Sep 3, 2001, 6:33 AM
Post #6 of 8
(1174 views)
Permalink
|
Hi Zopistas,
The winning answer was from Pavel V. Piankov
[pashah [at] cosmos-mebel] who had the following angle on life:
<dtml-call "REQUEST.set('total',0)">
<p>
<dtml-in "zsql.dbGetSalary(_,_.None)">
Name: <dtml-var name> - <dtml-var salary> salary<br>
<dtml-call "REQUEST.set('total',total+_.float(salary))">
</dtml-in>
Total: <dtml-var total>
</p>
..and in the process taught me a little about keeping variables around
in DTML -;^>= Thanks to Pavel for the help, I have agonized over this
for a humiliatingly unacceptable amount of time...
(forehead slap)
> -----Original Message-----
> From: Russell Hires [mailto:rhires [at] earthlink]
> Sent: Monday, September 03, 2001 15:27
> To: Mitch Pirtle
> Cc: zope-db [at] zope
> Subject: Re: [Zope-DB] ZSQL, sum() and you
>
>
> This is a suggestion and a question as I'm a relative Zope
> Newbie and an SQL
> Newbie while I'm at it...
>
> Why not have zope look at the figures returned in the column,
> and just add
> 'em up and then divide by the number of times it had a number
> to go through?
> Each row.column is an object, right? Is it possible to get
> the object's
> value, and then add it, like a "for" loop, but in DTML?
>
> Hope this is helpful, and if not, I hope I get a good answer myself!
>
> Russell
>
> On Monday 03 September 2001 03:43, Mitch Pirtle wrote:
> > > Scavenging the mail folder uncovered Mitch Pirtle's letter:
> > > > 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?
> > >
> > > maybe i don't understand correctly the problem, but wouldn't...
> > >
> > > SELECT *, sum(salary) as sum_of_salary FROM emp
> > >
> > > do it?
> >
> > Not in MySQL, and I believe/think/ASSume that's illegal
> SQL. (cannot
> > include GROUP statements within a non-GROUP query or
> something of the
> > sort).
> >
> > Basically, I'm returning all rows from a table, and then
> wanting a sum
> > from one column. In PHP, you run the query, display (via loop) the
> > rows, then calculate the sum of one column (from the same
> recordset,
> > without re-running the query). I cannot figure out the
> equivalent in
> > DTML, and am not excited to use python just to get a total.
> >
> > I know how to do this in PL/SQL, but no Oracle here - is
> there a ZSQL
> > equivalent?
> >
> > Anybody else out there? Bueller?
> >
> >
> > _______________________________________________
> > Zope-DB mailing list
> > Zope-DB [at] zope http://lists.zope.org/mailman/listinfo/zope-db
>
|
