Re: [SQLObject] SQL IN operator

2011-04-20 Thread kosset
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 >> r

Re: [SQLObject] SQL IN operator

2011-04-20 Thread Oleg Broytman
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_i

Re: [SQLObject] SQL IN operator

2011-04-20 Thread Oleg Broytman
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

[SQLObject] SQL IN operator

2011-04-20 Thread kosset
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 -