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.
