'identity' is probably a reserved word in sqlite. Try changing it to something else.
On May 8, 1:36 pm, winti <[email protected]> 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
