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/to generate 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.
