i changed it to myid and i get a error on:
KeyError: 'myid'

Stefan

On May 8, 8:51 pm, "mr.freeze" <nat...@freezable.com> wrote:
> 'identity' is probably a reserved word in sqlite. Try changing it to
> something else.
>
> On May 8, 1:36 pm, winti <stefan.winterb...@gmail.com> wrote:
>
>
>
> > Hello,
> > in a controller i define a temp db and want to return the results with
> > webgrid to a view.
> > I get a Keyerror on 'identity'.
>
> > Traceback (most recent call last):
> >   File "/data/projects/frameworks/web2py/applications/gluon/
> > restricted.py", line 178, in restricted
> >     exec ccode in environment
> >   File "/data/projects/frameworks/web2py/applications/applications/
> > eDir/controllers/default.py", line 190, in <module>
> >   File "/data/projects/frameworks/web2py/applications/gluon/
> > globals.py", line 96, in <lambda>
> >     self._caller = lambda f: f()
> >   File "/data/projects/frameworks/web2py/applications/applications/
> > eDir/controllers/default.py", line 187, in queryaddr
> >     return dict(resi1=res,grid=grid())
> >   File "/data/projects/frameworks/web2py/applications/applications/
> > eDir/modules/webgrid.py", line 229, in __call__
> >     field = db[t][f]
> >   File "/data/projects/frameworks/web2py/applications/gluon/sql.py",
> > line 1318, in __getitem__
> >     return dict.__getitem__(self, str(key))
> > KeyError: 'identity'
>
> > def xyz():
>
> > db=SQLDB('sqlite:memory:')
> >         db.define_table("identity",
> >                 db.Field("user","string",default=""),
> >                 db.Field("ip","string",default=""),
> >                 db.Field("type","string",default=""))
>
> > ...
> > ...
> > ....
> > db.identity.insert(user=user,ip=ipreadeable,type=type)
> > ...
> > ...
>
> > grid = webgrid.WebGrid(crud)
> > grid.datasource = db(db.identity.id<0).select()
>
> > Any idea
>
> > Stefan

Reply via email to