Is it just me or is this archaic? -Thadeus
On Tue, Mar 9, 2010 at 6:48 PM, Russell <[email protected]> wrote: > The number is stored in a dictionary called '_extra'. The top part of > what you are getting is the dictionary key. Do something like this to > get just the number... > > row = db(...).select(db.some_table.amount.sum())[0] > answer = row.'_extra['SUM(some_table.amount) '] > > See pg 169 of the book. > > > On Mar 10, 1:23 pm, minh <[email protected]> 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 [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
