web2py version??

On Thu, Aug 23, 2012 at 10:00 PM, pylix <[email protected]> wrote:

> 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