urg. thanks. I just moved from MySQL to postgresql, so that must be
why it's being flagged, now.
On Mar 4, 11:46 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
> 'offset' is a keyword and cannot be used as a field name
>
> On Mar 4, 10:34 pm, weheh <richard_gor...@verizon.net> wrote:
>
> > This didn't used to issue a ticket until today. The only change I made
> > was to add a new table to my db. Any idea what might be causing this?
> > The db field is this:
>
> > db.Field('offset','double',requires=IS_FLOAT_IN_RANGE(-12.0,12.0)),
>
> > Traceback (most recent call last):
> > File "gluon/restricted.py", line 173, in restricted
> > exec ccode in environment
> > File "/web2py/applications/myapp/models/C_db.py", line 175, in
> > <module>
>
> > db.Field('offset','double',requires=IS_FLOAT_IN_RANGE(-12.0,12.0)),
> > File "gluon/sql.py", line 1275, in define_table
> > t._create(migrate=migrate, fake_migrate=fake_migrate)
> > File "gluon/sql.py", line 1694, in _create
> > self._db._execute(query)
> > File "gluon/sql.py", line 958, in <lambda>
> > self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
> > ProgrammingError: syntax error at or near "offset"
> > LINE 4: offset FLOAT8
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
