queries have to be of the form field operator value
value can (for double, string and integer) be an expression that contains fields like field < otherfield + 5 On May 1, 7:17 am, niknok <[email protected]> wrote: > I'm wondering why this doesn't work: > > delta=datetime.timedelta(seconds=15*60) > db(request.now>(db.qa.time_start+delta)).count() > > TypeError: can't compare datetime.datetime to Expression > > while this one does: > > delta=datetime.timedelta(seconds=15*60) > db(db.qa.time_start<(request.now-delta)).count() > > Struggled with that line all afternoon, and out of frustration decided > to transpose the values, and suddenly it worked. > > /r > Nik
