I have a following entry in controller and this works fine to list all
the fields in a table.
When I specify fields=['name'], then I got an error. What did I do
wrong ?
Here's my table:
---------------------------------
db.define_table('special',
Field('restaurant_id', db.restaurant),
Field('name'),
Field('price','double'),
Field('image','upload'),
format='%(name)s')
Controller (This works)
-------------------------------
def update():
grid = SQLFORM.grid(db.special.restaurant_id==request.args(0),
deletable=False,paginate=10,details=False,csv=False,searchable=False)
return dict(grid=grid)
Controller(This doesn't)
--------------------------------
def update():
grid =
SQLFORM.grid(db.special.restaurant_id==request.args(0),fields=['name'],deletable=False,
paginate=10,details=False,csv=False,searchable=False)
return dict(grid=grid)
Error:
-------------------------------
Traceback (most recent call last):
File "C:\web2py\gluon\restricted.py", line 194, in restricted
exec ccode in environment
File "C:/web2py/applications/Kyono_Lunch/controllers/default.py",
line 88, in <module>
File "C:\web2py\gluon\globals.py", line 149, in <lambda>
self._caller = lambda f: f()
File "C:\web2py\gluon\tools.py", line 2456, in f
return action(*a, **b)
File "C:/web2py/applications/Kyono_Lunch/controllers/default.py",
line 23, in update
grid =
SQLFORM.grid(db.special.restaurant_id==request.args(0),deletable=False,
paginate=10,details=False,csv=False,searchable=False,fields=['id'])
File "C:\web2py\gluon\sqlhtml.py", line 1588, in grid
if not field.readable: continue
AttributeError: 'str' object has no attribute 'readable'