Hi - new to Web2py and the group. I'm building an app that will need to
perform Sum and Max against large sets of data. As I'm getting familiar
with the DAL, I've tried the following (and other combinations) rather than
fall back to db.executesql.
I'm getting the correct result but can't figure out a way to get only the
result number (68) without the (SUM(rates.val02). Probably missing
something basic but I've tried a lot of combinations and can't seem to get
there.
Thanks in advance.
Model-
db.define_table('rates',
Field('rate_name', 'string'),
Field('val01', 'integer'),
Field('val02', 'integer'),
Controller-
def sum1():
query = db.rates.val02.sum()
return dict(sum1 = db().select(query))
View-
{{=sum1}}
Result-
SUM(rates.val02)68
