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.