Thanks!
I got this working, but it seems I can't use my existing databases due
to a requirement that every table have a pre-existing id field which
is primary. :(
-Ben
On Mar 26, 12:26 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
> Something is wrong in your model For example
>
> SQLField("employee_password", "VARCHAR",
> length=128,default=None))
>
> should be
>
> Field("employee_password", "password", length=128,default=None))
>
> field types are listed here:http://web2py.com/book/default/section/6/4
>
> If you have 'INTEGER' it should be 'integer'.
>
> User Field, not SQLField (deprecated but aliased).
>
> Probably you should use built-in auth, and not redefine your own
> employee table.
>
> On Mar 26, 11:09 am, "Ben W." <bhw2...@gmail.com> wrote:
>
>
>
> > Any ideas? I usedhttp://gaesql.appspot.com/togenerate the code...
>
> > Error traceback
>
> > Traceback (most recent call last):
> > File "/home/ben/www/web2py/gluon/restricted.py", line 173, in
> > restricted
> > exec ccode in environment
> > File "/home/ben/www/web2py/applications/msi/models/db.py", line 83,
> > in <module>
> > SQLField("employee_password", "VARCHAR", length=128,
> > default=None))
> > File "/home/ben/www/web2py/gluon/sql.py", line 1275, in define_table
> > t._create(migrate=migrate, fake_migrate=fake_migrate)
> > File "/home/ben/www/web2py/gluon/sql.py", line 1628, in _create
> > (field.type, field.name)
> > SyntaxError: Field: unknown field type: INTEGER for employee_id
--
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.
