[Zope] how to accumulate data using ZPT
Hugo Ramos
ramosh at gmail.com
Fri May 20 05:36:53 EDT 2005
On 5/20/05, Tino Wildenhain <tino at wildenhain.de> wrote:
> Am Freitag, den 20.05.2005, 09:52 +0100 schrieb Hugo Ramos:
> > Yellow,
> >
> > What DBMS are you using??? MySQL???
> > If so just have a sql method do this:
> > ==========
> > SELECT COUNT( '*' ) AS total
> > FROM yourtable
> > ==========
>
> Are you sure about the ' '? looks strange.
It works both ways... With or without the ' ' !
> > Then call the variable total where you need it!
> >
> > Regards
> > hr
> >
> >
> > On 5/20/05, prabuddha ray <buddharay at gmail.com> wrote:
> > > I've this report wherein i've to print the column total iin last row.
> > > column values are from database.
> > > so far I'm a total loss. do i need to have cookies to store this total?
>
> simplest solution if you need the data anyway:
> a python script where you do the zsql method
>
> results=context.whateverZSQLMethod(args...)
>
> return context.yourPageTemplate(results=results,count=len(results))
>
> and use
>
> tal:content="options/count" in the template where you need count.
> If its a sum you need, just work over your resultset or use a separate
> query.
>
> Easiest to work over result set (especially if the select is costy)
>
>
> results=context.whateverZSQLMethod(args...)
>
> total=0
> for item in results:
> if item.value: # this handles the case of nulls
> total+=item.value
>
> and use the total as argument:
>
> return context.yourPageTemplate(results=results,
> count=len(results),
> total=total)
>
>
> --
> Tino Wildenhain <tino at wildenhain.de>
>
>
--
Hugo Ramos - ramosh at gmail.com
More information about the Zope
mailing list