db.table.x.contains([1, 2, 3], all=True)
Anthony
On Monday, October 6, 2014 12:29:23 PM UTC-4, mweissen wrote:
>
> 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.
