Hi everybody,

It seems common filters do nothing is there is no WHERE clause in the SQL.

Following book example:

    db.blog_post.insert(subject='one', post_text=request.utcnow, is_public=
True)
    db.blog_post.insert(subject='two', post_text=request.utcnow, is_public=
False)

this gives no WHERE clause:

    db()._select(db.blog_post.ALL, limitby=(0,5)) 

while this:

    db(db.blog_post)._select(db.blog_post.ALL, limitby=(0,5)) 

gives this the expected clause:

    ... WHERE ((blog_post.id IS NOT NULL) AND (blog_post.is_public = 'T')) 
...


Is this intentionally or is it a bug?.

Thanks!

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to