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
