> > query=(db.auth_membership.user_id==db.auth_user.id > )(db.courses.teacher_id==db.auth_user.id)(db.auth_membership.group_id== > db.auth_group.id)(db.auth_group.role=='teacher') >
The above is not valid syntax. A Set object is callable, and when called, it returns another Set object, so you can chain Sets: myset = db(query1)(query2)(query3) If you instead want to work with Query objects, you have to make explicit conjunctions using the "&" operator: myquery = query1 & query2 & query3 Anthony -- 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.