I think you can't pass a instruction : Not working : db(db.event.datetime > request.now ).select(db.events.ALL)
Try : is_now = request.now db(db.event.datetime > is_now ).select(db.events.ALL) or maybe you need time delta from python datetime... Richard On Thu, Oct 20, 2011 at 9:47 AM, Web2Py Freak <[email protected]>wrote: > Dear All , > > i have a table called events which looks like this : > > > db.define_table('events',Field('title'),Field('description','text'),Field('datetime','datetime',default=request.now,readable=False,writable=False)) > > > and in my default/events.html i want to get the event the the > datetime in it is less that now , am trying to do it like this : > > events=db(db.event.datetime > request.now ).select(db.events.ALL) > > > but its not working , do you have any idea how to do it ?? > > > Best reagards, > Hassan alnatour >
