Massimo, That pegs my CPU for a bit and then errors: File "/Users/lrivers/Documents/CurrentProjects/SPTI/spowertech_webappserver1/gluon/sql.py", line 734, in __getitem__ return dict.__getitem__(self, key) KeyError: 'MIN(data_table.ReqTime)'
Here's my code: m=db4.data_table.ReqTime.min() firsttime = db4(db4.data_table).select().first()[m] On Nov 17, 2010, at 13:30 , mdipierro wrote: > m=db.data_table.reqtime.min() > value = db(db.date_table).select().first()[m] > > On Nov 17, 11:43 am, Lorin Rivers <lriv...@mosasaur.com> wrote: >> executesql('select min(reqtime) from data_table;') >> -- >> Lorin Rivers >> Mosasaur: Killer Technical Marketing <http://www.mosasaur.com> >> <mailto:lriv...@mosasaur.com> >> 512/203.3198 (m) -- Lorin Rivers Mosasaur: Killer Technical Marketing <http://www.mosasaur.com> <mailto:lriv...@mosasaur.com> 512/203.3198 (m)