Hi,
here is the situation:
TABLE:
db.define_table('amsg',
Field('ufrom'),
Field('uto', 'reference auth_user'),
Field('mailbox_to_use','list:string',requires=IS_IN_SET((
'internal','private'),multiple=True),
default=['internal']),
Field('subject'),
Field('jatom','json',required=True),
Field('created_date',default=str(request.now.date())),
Field('created_on','datetime',required=True,default=request.
now))
db.amsg.body = Field.Virtual('body',
lambda row: ''.join('{0}\n{1}\n\n'.format(k,' '.join([vi.encode("utf-8")
for vi in v])) for k,v in row.amsg.jatom.items()))
CONTROLLER FUNCTION
def show_amsg():
q = db.amsg.id == request.args(0)
fld=[db.amsg.ufrom,db.amsg.uto,db.amsg.subject,db.amsg.created_date,db.
amsg.body]
hd = {'amsg.ufrom':'From','amsg.uto':'To','amsg.subject':'subject',
'amsg.created_date':'date','amsg.body':'message'}
form = SQLFORM.grid(q,fields=fld,headers=hd,editable=False,create=False,
paginate=12,csv=False,user_signature=False)
return dict(form=form)
Traceback (most recent call last):
File "/opt/web2py/gluon/restricted.py", line 227, in restricted
exec ccode in environment
File "/opt/web2py/applications/prox/controllers/default.py"
<http://127.0.0.1:8000/admin/default/edit/proxima/controllers/default.py>, line
576, in <module>
File "/opt/web2py/gluon/globals.py", line 412, in <lambda>
self._caller = lambda f: f()
File "/opt/web2py/applications/prox/controllers/default.py"
<http://127.0.0.1:8000/admin/default/edit/proxima/controllers/default.py>, line
366, in show_amsg
form =
SQLFORM.grid(q,fields=fld,headers=hd,editable=False,create=False,paginate=12,csv=False,user_signature=False)
File "/opt/web2py/gluon/sqlhtml.py", line 2710, in grid
value = row[str(field)]
File "/opt/web2py/gluon/packages/dal/pydal/objects.py", line 76, in
__getitem__
raise KeyError
KeyError
what's wrong ??
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
