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