You might try using the "rname" feature:
Field('state', rname='st')
or:
Field('state', rname='"state"')
web2py will use "state" as the name, but the database will see the name as
"st" (or in the second case, the name "state" is passed to the database,
but it is surrounded by double quotes, so it won't be interpreted as a SQL
keyword in any SQL statements).
Anthony
On Sunday, October 25, 2015 at 4:48:10 PM UTC-4, pbreit wrote:
>
> I get the whole reserved word conflict thing but am surprised that it
> can't or isn't worked around? The lists are pretty long and reserve a
> number of good words like "state" and "group".
>
--
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.
