Yeah a day of not sleeping well make my eyes skip it lol! On Sat, Nov 20, 2010 at 11:34 PM, Lorin Rivers <lriv...@mosasaur.com> wrote:
> 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) > > >
