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