something like this is not work either
e.g.
table= db.test
search = request.vars.search
field_objects = [f for f in table]
if search:
for field_object in field_objects:
rows = db(field_object.contains(search)).select()
Traceback
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
Traceback (most recent call last):
File "C:\web2py\gluon\restricted.py", line 227, in restricted
exec ccode in environment
File "C:/web2py/applications/freelancer/controllers/service.py"
<https://127.0.0.1/admin/default/edit/freelancer/controllers/service.py>, line
19, in <module>
File "C:\web2py\gluon\globals.py", line 412, in <lambda>
self._caller = lambda f: f()
File "C:/web2py/applications/freelancer/controllers/service.py"
<https://127.0.0.1/admin/default/edit/freelancer/controllers/service.py>, line
13, in browse
return freelancer_default.show_0(table, link_page)
File "applications\freelancer\modules\freelancer_default.py", line 59, in
show_0
rows = current.db(field_object.contains(search)).select(limitby = limitby,
File "C:\web2py\gluon\packages\dal\pydal\objects.py", line 1247, in contains
raise SyntaxError("contains used with incompatible field type")
SyntaxError: contains used with incompatible field type
any hints or suggestion to search all the fields in database table?
best regards,
stifan
--
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.
