Possible bug when searching in SQLFORM.grid with order activated. To reproduce: 1. SQLFORM.grid, advanced_search = True 2. Click a column header on the grid to activate 'order' 3. Click 'search' (with or without keyword) 4. Error as follows: Traceback (most recent call last): File "C:\Users\User\Desktop\web2py\gluon\restricted.py", line 219, in restricted exec(ccode, environment) File "C:/Users/User/Desktop/web2py/applications/bsmOnline/controllers/library.py" <http://127.0.0.1:8000/admin/default/edit/bsmOnline/controllers/library.py>, line 113, in <module> File "C:\Users\User\Desktop\web2py\gluon\globals.py", line 430, in <lambda> self._caller = lambda f: f() File "C:/Users/User/Desktop/web2py/applications/bsmOnline/controllers/library.py" <http://127.0.0.1:8000/admin/default/edit/bsmOnline/controllers/library.py>, line 56, in region create=can_add_library, editable=can_edit_library, deletable= can_delete_library) File "C:\Users\User\Desktop\web2py\gluon\tools.py", line 3951, in f return action(*a, **b) File "C:/Users/User/Desktop/web2py/applications/bsmOnline/models/db1.py" <http://127.0.0.1:8000/admin/default/edit/bsmOnline/models/db1.py>, line 78, in library grid = SQLFORM.grid(query, maxtextlength=80, csv=False, **kwargs) File "C:\Users\User\Desktop\web2py\gluon\sqlhtml.py", line 2804, in grid otablename, ofieldname = order.split('~')[-1].split('.', 1) AttributeError: 'list' object has no attribute 'split'
Upon clicking the 'search' button, it seems that the 'order' in request .vars is transformed from string to list, such that order = 'anykey' becomes 'order = ['anykey', 'anykey'], hence, the error. Workaround for me: if request.vars: if 'order' in request.vars: request.vars.order = request.vars.order[0] Can somebody please confirm or am I doing something wrong? -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/fb471182-230f-42d1-aebe-c3da4c06fe8cn%40googlegroups.com.