ok no more errors.
If I search for a name (John) for example in the table i get everything, Or
for his ID (11) I get everything.
I realise this is a join table (Many to Many) so it's no big deal but the
search here is not very useful.
I will need to implement special grids for these situations.
Thanks for the fix.
On Tue, Aug 1, 2017 at 10:46 AM, Paul Ellis <eddie.dig...@gmail.com> wrote:
> I am getting this error only when searching the auth_membership table
>
> I have put in a basic 'appadmin' in my webapp. I call it 'tooladmin' to
> differentiate from the built in stuff.
>
> I use this function to edit any database table:
> def manage_table():
> tablename = request.args(0)
> pagetitle = H4('{0} {1}'.format(T('Manage'), tablename))
> buttongroup = [_btn_index()]
> table = db[tablename]
> pagecontent = SQLFORM.grid(table, args=[request.args(0)])
>
>
> response.view = 'tooladmin_core.html'
> return dict(pagetitle=pagetitle, buttongroup=buttongroup,
> pagecontent=pagecontent)
>
> The search feature on the SQLFORM.grid is throwing this error when
> searching the auth_membership table:
>
> 1.
> 2.
> 3.
> 4.
> 5.
> 6.
> 7.
> 8.
> 9.
> 10.
> 11.
> 12.
> 13.
> 14.
>
> Traceback (most recent call last):
> File "E:\web2py\gluon\restricted.py", line 227, in restricted
> exec ccode in environment
> File "E:/web2py/applications/OfferTool/controllers/tooladmin.py"
> <http://127.0.0.1:8000/admin/edit/OfferTool/controllers/tooladmin.py>, line
> 262, in <module>
> File "E:\web2py\gluon\globals.py", line 417, in <lambda>
> self._caller = lambda f: f()
> File "E:/web2py/applications/OfferTool/controllers/tooladmin.py"
> <http://127.0.0.1:8000/admin/edit/OfferTool/controllers/tooladmin.py>, line
> 136, in manage_table
> pagecontent = SQLFORM.grid(table, args=[request.args(0)])
> File "E:\web2py\gluon\sqlhtml.py", line 2526, in grid
> subquery = SQLFORM.build_query(sfields, keywords)
> File "E:\web2py\gluon\sqlhtml.py", line 1827, in build_query
> ) for k in key.split()])
> TypeError: reduce() of empty sequence with no initial value
>
>
>
> --
> 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 a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/
> topic/web2py/UnN6AyOh2Lg/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
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/d/optout.
