Ah, this makes more sense now.
On Mar 9, 9:03 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
> s=db.some_table.amount.sum()
> row = db(...).select(s).first()
> answer = row[s]
>
> On Mar 9, 8:23 pm, Thadeus Burgess <thade...@thadeusb.com> wrote:
>
> > Is it just me or is this archaic?
>
> > -Thadeus
>
> > On Tue, Mar 9, 2010 at 6:48 PM, Russell <russell.mcmur...@gmail.com> 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 <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
> > > athttp://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 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.
