hi, is it possible to use 2 or more query on db? i just tried on http://web2py.com/book/default/chapter/03#Adding-CRUD
e.g. comments = db(db.comment.image_id == image.id and db.comment.is_active == True).select(orderby = ~db_comment.id) my question is when i put db.comment.is_active the page show all the comment that active, i think the correct one is to show the comment that related with image and status is active, but the page shown up unexpectaly. when i follow exactly same like on the book everything is fine, i just want to add some query on that. is there any way to do that? thank you so much for any hints or pointers.