[web2py] Re: first attempt to use mysql web2py = unknown field type: INTEGER

2010-03-28 Thread DenesL
Depending on your table definitions you still have two options: 1) If your tables define a primary key on an integer field not named 'id' you can alias it: http://groups.google.com/group/web2py/msg/86838b9b792a236e 2) If your tables define multiple fields as primary key you could still use them

[web2py] Re: first attempt to use mysql web2py = unknown field type: INTEGER

2010-03-27 Thread Ben W.
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    

[web2py] Re: first attempt to use mysql web2py = unknown field type: INTEGER

2010-03-26 Thread mdipierro
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