hi,
how to put query in sqlform.grid or smartgrid?
*code*
def category():
query=db.category
grid=SQLFORM.smartgrid(query)
return locals()
i want to make a query for example db.category.id > 10, and i don't know
how to do it, is there any hints or reference for this?
when i tried to replace the query=db.category.id > 10 it will return an
error :
Traceback
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
Traceback (most recent call last):
File "/home/stifank/Desktop/web2py/gluon/restricted.py", line 212, in
restricted
exec ccode in environment
File
"/home/stifank/Desktop/web2py/applications/rental/controllers/default.py"
<http://127.0.0.1:8000/admin/default/edit/rental/controllers/default.py>, line
152, in <module>
File "/home/stifank/Desktop/web2py/gluon/globals.py", line 193, in <lambda>
self._caller = lambda f: f()
File "/home/stifank/Desktop/web2py/gluon/tools.py", line 2942, in f
return action(*a, **b)
File
"/home/stifank/Desktop/web2py/applications/rental/controllers/default.py"
<http://127.0.0.1:8000/admin/default/edit/rental/controllers/default.py>, line
90, in booking
grid=SQLFORM.smartgrid(query)
File "/home/stifank/Desktop/web2py/gluon/sqlhtml.py", line 2454, in smartgrid
if request.args(len(args)) != table._tablename:
AttributeError: 'Query' object has no attribute '_tablename'
Error snapshot [image:
help]<http://127.0.0.1:8000/admin/default/ticket/rental/127.0.0.1.2013-03-07.09-47-49.5e19acec-adc5-410c-b3ad-0df5e5e6924e#>
<type 'exceptions.AttributeError'>('Query' object has no attribute
'_tablename')
thank you so much before
--
---
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/groups/opt_out.
