[web2py] Re: Translate this SQL to DAL?

2010-12-12 Thread mdipierro
More verbosely: max_reqtime = db.arraydata_table.reqtime.max() rows=db(db.arraydata_table.rollupid==0).select(max_reqtime) print rows.first()(max_reqtime) On Dec 12, 2:27 pm, DenesL wrote: > rows=db(db.arraydata_table.rollupid==0).select(db.arraydata_table.reqtime.max()) > > On Dec 12, 2:40 pm,

[web2py] Re: Translate this SQL to DAL?

2010-12-12 Thread DenesL
rows=db(db.arraydata_table.rollupid==0).select(db.arraydata_table.reqtime.max()) On Dec 12, 2:40 pm, Lorin Rivers wrote: > THere are a few aspects of the DAL that I can't  quite get my head around. > For example, how would I do this? > > select max(reqtime) from arraydata_table where rollupid