It is in the book: <http://web2py.com/book/default/chapter/06#Logical-Operators>
On Nov 19, 2010, at 20:00 , Bruno Rocha wrote: > Not mentioned in the book that you can get the NOT IN SQL expression > > my_list = [1,2,3,4] > > NOT IN LIST: db(~(db.product.id.belongs(my_list))).select() > > IN LIST: db(db.product.id.belongs(my_list)).select() > > > 2010/11/19 Bruno Rocha <rochacbr...@gmail.com> > >> http://web2py.com/book/default/chapter/06#belongs >> >> >> >> 2010/11/19 Phyo Arkar <phyo.arkarl...@gmail.com> >> >> GOT IT >>> >>> db.table.key.belongs >>> >>> >>> I cant find it in web2py book is there is? >>> >>> >>> On Sat, Nov 20, 2010 at 8:11 AM, Phyo Arkar <phyo.arkarl...@gmail.com>wrote: >>> >>>> This can be done in Query easily as >>>> >>>> SELECT * FROM table WHERE table.id IN (1,2,4,5) >>>> >>>> Theres no DAL equvlient ? i have to execute SQL? >>>> >>>> >>>> On Sat, Nov 20, 2010 at 8:00 AM, Phyo Arkar >>>> <phyo.arkarl...@gmail.com>wrote: >>>> >>>>> Eratta : >>>>> >>>>> >>>>> >>>>> >>>>> to_get=[1,2,4,5] >>>>> >>>>> q= db.casedb.id in to_get # Guess this wont work? >>>>> >>>>> db(q).select(db.casedb.ALL) >>>>> >>>>> On Sat, Nov 20, 2010 at 7:54 AM, Phyo Arkar >>>>> <phyo.arkarl...@gmail.com>wrote: >>>>> >>>>>> >>>>>> to_get=[1,2,4,5] >>>>>> >>>>>> q= db.casedb.id in toget >>>>>> db(q).select(db.casedb.ALL) >>>>> >>>>> >>>>> >>>> >>> >> >> >> -- >> >> Bruno Rocha >> http://about.me/rochacbruno/bio >> > > > > -- > > Bruno Rocha > http://about.me/rochacbruno/bio -- Lorin Rivers Mosasaur: Killer Technical Marketing <http://www.mosasaur.com> <mailto:lriv...@mosasaur.com> 512/203.3198 (m)