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