Hello Jeff, I've posted a here but it seems to be pending approval. I notice no responses to your post. Is this site dead? Is Web2py dead? Did everyone go to Django? Thanks in advance for your reply.
On Tuesday, August 1, 2023 at 2:19:28 AM UTC-4 [email protected] wrote: > 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/daadf38e-751f-43fe-b6de-934aa496a57cn%40googlegroups.com.
