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.

-- 



Reply via email to