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.