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)


Reply via email to