Re: [SQLObject] subquery with IN operator

2007-02-26 Thread Daniel Nogradi
> > I would like to build an SQL query with sqlbuilder that contains > > several IN operators but I don't seem to succeed. The model is quite > > simple, there are several cities, each city contains a number of > > buildings, each building contains a number of floors and each floor > > contains a n

Re: [SQLObject] subquery with IN operator

2007-02-25 Thread Oleg Broytmann
On Sun, Feb 25, 2007 at 11:11:54PM +0100, Daniel Nogradi wrote: > class city(SQLObject): > name = StringCol( ) > buildings = MultipleJoin( 'building' ) > > class building(SQLObject): > name = StringCol( ) > complex = ForeignKey( 'city' ) > floors = MultipleJoin( 'floor' ) > >

Re: [SQLObject] subquery with IN operator

2007-02-25 Thread Daniel Nogradi
> The problem is that with the above model > both building.q.complex and building.q.floors throw an AttributeError Sorry for the typo, building.q.complex should have been building.q.city. - Take Surveys. Earn Cash. Influence

[SQLObject] subquery with IN operator

2007-02-25 Thread Daniel Nogradi
Hi list, I would like to build an SQL query with sqlbuilder that contains several IN operators but I don't seem to succeed. The model is quite simple, there are several cities, each city contains a number of buildings, each building contains a number of floors and each floor contains a number of r