Please print
db(db.message_sent.created_on<request.now)._select()
and let me know what you get.
Massimo
On Feb 25, 11:29 pm, "Sebastian E. Ovide" <sebastianov...@gmail.com>
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 web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
