to summarize..... a Query is a condition
q = db.auth_user.id > 0 The Set takes the Query and asks to the backend the results rows = db(q).select() The grid can exclusively take either a table (in which case, it knows it has to query for all the records in that table) or a query. Since it's the grid who ultimately chooses how ordered the table is, how many records to display, etc etc etc, you must let it (the grid) fiddle with the necessary db(q).select(orderby=...., limitby=.....) because the only thing needed is q. -- 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/groups/opt_out.