yes I'm sure... it is the 1.56.4... with logging.debug(db(db.message.created_on<request.now)._select())
I get DEBUG 2009-02-26 13:59:05,926 default.py] (<google.appengine.ext.db.Query object at 0x9b40dac>, 'message', ['id', 'subject', 'body', 'from_user', 'from_cas_user_id', 'to_user', 'to_cas_user_id', 'read', 'created_on']) On Thu, Feb 26, 2009 at 5:13 AM, mdipierro <[email protected]> wrote: > > btw. It works fine for me. Are you sure you did not accidentally edit > the sql.py file? > > Massimo > > On Feb 25, 11:29 pm, "Sebastian E. Ovide" <[email protected]> > wrote: > > Hi All, > > > > I have a model like this: > > > > db.define_table('message_sent', > > ... > > ...), > > SQLField('created_on','datetime', > > readable=False, > > writable=False, > > default=request.now), > > ) > > > > so any query like db(db.message_sent.created_on<request.now).select() > should > > return everyting... as request,now is less than created_on ... > > > > instead it returns nothing... if I use the inequality filter > (greater > > than) it returns the whole table. > > > > any ideas ? is this a web2py bug? > > > > (for example with request.now equal to 2009-02-26 05:26:53.356458 I get > > records with 2009-02-26 02:25:38.951329.... it is less than... not > > bigger!!!!) > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
