Here's my model
db = DAL('sqlite://storage.sqlite')
db.define_table('person',
Field('name', requires=IS_NOT_EMPTY()),
Field('phone', requires=IS_NOT_EMPTY()),
Field('address', requires=IS_NOT_EMPTY()),
Field('city', requires=IS_NOT_EMPTY()),
Field('state', requires=IS_IN_SET(['NY' ,'NJ' ,'CN'])),
Field('zip', requires=IS_NOT_EMPTY()),
Field('year', requires=IS_NOT_EMPTY()),
Field('model', requires=IS_NOT_EMPTY()),
Field('make', requires=IS_NOT_EMPTY()),
Field('engine', requires=IS_NOT_EMPTY()),
Field('starts', 'boolean'),
Field('foward', 'boolean'),
Field('reverse', 'boolean'),
Field('complaint', 'text'))
the controller is
def freequote():
form = SQLFORM(db.person)
return dict(form=form)
and the view....
{{extend 'layout.html'}}
{{=form}}
I'm getting this error when i try to view the page
<type 'exceptions.KeyError'> 'person'
Traceback (most recent call last):
File "gluon/restricted.py", line 205, in restricted
File "/controllers/default.py"
<http://127.0.0.1:8000/admin/default/edit/transmission/controllers/default.py>,
line 10, in <module>
File "gluon/globals.py", line 173, in <lambda>
File "/controllers/default.py"
<http://127.0.0.1:8000/admin/default/edit/transmission/controllers/default.py>,
line 8, in freequote
File "gluon/dal.py", line 6343, in __getattr__
File "gluon/dal.py", line 6337, in __getitem__
KeyError: 'person'
not sure why i'm getting a keyerror is the table is defined.
--