On Tuesday, October 11, 2016 at 1:42:07 PM UTC-7, Kirill Shatalaev wrote:
>
>
> Hello.
>
> Dont know why, but I see tables and fields surrounded by backticks on
> appadmin.
>
> For example:
>
> `component`.`id` `component`.`name`
> So, when I try to sort table clicking by field name, I get error:
>
> Traceback (most recent call last):
> File
> "/home/ksh/PycharmProjects/barlist/web2py/applications/barlist/controllers/appadmin.py",
> line 266, in select
> orderby=eval_in_global_env(orderby))
> File
> "/home/ksh/PycharmProjects/barlist/web2py/applications/barlist/controllers/appadmin.py",
> line 95, in eval_in_global_env
> exec ('_ret=%s' % text, {}, global_env)
> File "<string>", line 1
> _ret=db.`component`.`id`
> ^
> SyntaxError: invalid syntax
>
>
> How can be this fixed? I use no mysql reserved keywords on table's/field's
> names, as far as I know.
>
--
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].
For more options, visit https://groups.google.com/d/optout.
