[web2py] Re: How do you define a column name on summed field (i.e. how to do the equivalent of an sql 'select ..... as colname'

[Massimo Di Pierro]

you can do:

for row in rows: row.foo = row[foo]

and then you do not have to pass it.

On Feb 27, 10:40 pm, Anthony <abasta...@gmail.com> wrote:
> > I am not convinced that
>
> > rows = db().select(db.table.field1.sum() as foo)
> > +  {{=row.foo}}
>
> > is any simpler than
>
> > foo = db.table.field1.sum()
> > rows = db().select(foo)
> > +  {{=row[foo]}}
>
> The problem is in the latter case, you have to pass foo to the view -- not
> a big deal with just foo, but more cumbersome with multiple expressions.
>
> Anthony