I have a Field("x", "list:integer")
I want to find all rows where x==[1,2,3] (it's necessary to compare the
whole list) and I tried:
1. db(db.table.x==[1,2,3])
2. db(db.table.x=="|1|2|3|")
3. db.executesql("select * from mytable where x='|1|2|3|';")
#1 & #2 did not work (yes, I expected that it would not work :-))
#3 did the job.
Is there any simple way using web2py methods?
Regards, Martin
--
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.
