rows=db(...).select(db.some_table.amount.sum())
print rows.first()[db.some_table.amount.sum()]
On Mar 9, 6:23 pm, minh <mdn0...@gmail.com> wrote:
> I couldn't find much documentation on sum() and I'm not sure how to
> use it.
>
> If I have something like
>
> define_table('some_table',
> Field('amount', 'integer')
> ...
>
> I try db(...).select(db.some_table.amount.sum())
>
> When I print it out, I get something like:
>
> SUM(some_table.amount)
> 300
>
> How do I get it to print just the number?
>
> Thanks.
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
