sqlobject-discuss

[SQLObject] SQL IN operator

[kosset <kos...@go...>]

Hello,

I know this is a simple question, but I have no idea how to write this 
query:

SELECT * FROM downloaded WHERE mess_id IN (46,47,100)

in SQLObject. I mean that I don't know how to use SQL IN operator with 
SQLObject...

Could anyone help me with this :)?

kos

Re: [SQLObject] SQL IN operator

[Oleg B. <ph...@ph...>]

On Wed, Apr 20, 2011 at 10:45:05PM +0200, kosset wrote:
> SELECT * FROM downloaded WHERE mess_id IN (46,47,100)

from sqlbuilder import IN

result = Downloaded.select(IN(Downloaded.q.mess_id, [46,47,100]))

   SQLBuilder[1] is still underdocumented, sorry.

1. http://sqlobject.org/SQLBuilder.html

Oleg.
-- 
     Oleg Broytman            http://phdru.name/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

Re: [SQLObject] SQL IN operator

[Oleg B. <ph...@ph...>]

On Thu, Apr 21, 2011 at 12:55:32AM +0400, Oleg Broytman wrote:
> On Wed, Apr 20, 2011 at 10:45:05PM +0200, kosset wrote:
> > SELECT * FROM downloaded WHERE mess_id IN (46,47,100)
> 
> from sqlbuilder import IN

from sqlobject.sqlbuilder import IN

> result = Downloaded.select(IN(Downloaded.q.mess_id, [46,47,100]))

Oleg.
-- 
     Oleg Broytman            http://phdru.name/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

Re: [SQLObject] SQL IN operator

[kosset <kos...@go...>]

W dniu 2011-04-20 23:01, Oleg Broytman pisze:
> On Thu, Apr 21, 2011 at 12:55:32AM +0400, Oleg Broytman wrote:
>> On Wed, Apr 20, 2011 at 10:45:05PM +0200, kosset wrote:
>>> SELECT * FROM downloaded WHERE mess_id IN (46,47,100)
>> from sqlbuilder import IN
> from sqlobject.sqlbuilder import IN
>> result = Downloaded.select(IN(Downloaded.q.mess_id, [46,47,100]))
> Oleg.
It works like a charm! Thank you!

kos