My controller: def pwrtable():
powerTable.dtfeatures['sScrollY'] = '100%' powerTable.dtfeatures['sScrollX'] = '100%' powerTable.headers = 'fieldname:capitalize' powerTable.showkeycolumn = False powerTable.dtfeatures['bJQueryUI'] = request.vars.get('jqueryui',True) powerTable.uitheme = request.vars.get('theme','redmond')#'smoothness' / 'redmond' /'cupertino' powerTable.dtfeatures['sPaginationType'] = request.vars.get('pager','scrolling') # two_button full_numbers powerTable.dtfeatures['sScrollXInner'] = '100%' powerTable.dtfeatures['bScrollCollapse'] = True powerTable.dtfeatures['bScrollInfinite'] = True powerTable.dtfeatures['iScrollLoadGap'] = 10 powerTable.dtfeatures['bAutoWidth'] = True powerTable.dtfeatures['bPaginate'] = True powerTable.dtfeatures['bLengthChange'] = True powerTable.dtfeatures['bInfo'] = True powerTable.dtfeatures['bProcessing'] = True powerTable.dtfeatures['iDisplayLength'] = 20 powerTable.dtfeatures['iDisplayStart'] = 0 powerTable.dtfeatures['sDom'] = '<"top"i>rt<"bottom"flp<"clear">' powerTable.dtfeatures['asStripClasses'] = ['odd','even'] powerTable.columnsearch = False return (powerTable) r1 = db((db.t_registration_form.active==True)& (db.t_registration_form.f_attendee == db.auth_user.id ) ).select(db.auth_user.id, db.auth_user.first_name, db.auth_user.last_name, db.auth_user.title, db.t_registration_form.f_payment_postal_address, db.t_registration_form.f_payment_physical_address, db.t_registration_form.f_accommodation_week1, db.t_registration_form.f_accommodation_week2, db.t_registration_form.f_agree, orderby=db.t_registration_form.course_week1|db.t_registration_form.course_week2) pt = pwrtable() pt.source = r1 pt.headers = "fieldname:capitalize" pt.truncate = 255 pt.keycolumn = 'auth_user.id' pt.columnsearch = True rows = pt.create() #rows = SQLTABLE(r1, headers="fieldname:capitalize") return dict(rows = rows, message = message) When I use this I get the following error: 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. Traceback (most recent call last): File "/home/js/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/home/js/web2py/applications/ada/controllers/default.py" <http://localhost:8000/admin/default/edit/ada/controllers/default.py>, line 253, in <module> File "/home/js/web2py/gluon/globals.py", line 95, in <lambda> self._caller = lambda f: f() File "/home/js/web2py/gluon/tools.py", line 2349, in f return action(*a, **b) File "/home/js/web2py/applications/ada/controllers/default.py" <http://localhost:8000/admin/default/edit/ada/controllers/default.py>, line 238, in show_registrations rows = pt.create() File "/home/js/web2py/applications/ada/models/plugin_powertable.py" <http://localhost:8000/admin/default/edit/ada/models/plugin_powertable.py>, line 810, in plugin_powertable PowerTable(), File "/home/js/web2py/applications/ada/models/plugin_powertable.py" <http://localhost:8000/admin/default/edit/ada/models/plugin_powertable.py>, line 219, in __init__ _id = record.id File "/home/js/web2py/gluon/dal.py", line 3241, in __getattr__ return self[key] File "/home/js/web2py/gluon/dal.py", line 3232, in __getitem__ return dict.__getitem__(self, key) KeyError: 'id' Why? If I Do not select db.auth_user.id and comment the pt.keycolumn = ... line the same happens. There is no problem when I use either selection with SQLTABLE. Regards Johann -- May grace and peace be yours in abundance through the full knowledge of God and of Jesus our Lord! His divine power has given us everything we need for life and godliness through the full knowledge of the one who called us by his own glory and excellence. 2 Pet. 1:2b,3a