Hi, I want to fetch all the auth_group list of a user from auth_user mapping auth_membership.
--------------------------------------------- query = db((db.auth_group.id==db.auth_membership.group_id) & (db.auth_user.id==db.auth_membership.user_id) & (db.auth_user.id==auth.user.id)).select(db.auth_group.ALL) * # When I do the return over here, I am able to see the required data. But when I send it to the SQLFORM.grip it through the execption given below* * #return dict(table=where) * displayFields = [db.auth_group.role, db.auth_group.description] displayHeaders = {'auth_group.role': T('Role'), 'auth_group.description' : T('Description')} table = SQLFORM.grid(query, #left=left, fields=displayFields, headers=displayHeaders, deletable=False, create=True, editable=False, details=False, csv=False, links=[lambda row: A("Edit", _href=URL('manage_group', args=[row.id]))], paginate=10) return dict(table=table) --------------------------------------------- Traceback (most recent call last): File "/home/www-data/web2py/gluon/restricted.py", line 212, in restricted exec ccode in environment File "/home/www-data/web2py/applications/Telematics/controllers/group.py" <http://127.0.0.1:8000/admin/default/edit/Telematics/controllers/group.py>, line 64, in <module> File "/home/www-data/web2py/gluon/globals.py", line 194, in <lambda> self._caller = lambda f: f() File "/home/www-data/web2py/gluon/tools.py", line 3022, in f return action(*a, **b) File "/home/www-data/web2py/applications/Telematics/controllers/group.py" <http://127.0.0.1:8000/admin/default/edit/Telematics/controllers/group.py>, line 22, in list_groups paginate=10) File "/home/www-data/web2py/gluon/sqlhtml.py", line 1861, in grid db = query._db AttributeError: 'Rows' object has no attribute '_db' -- 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.