> > 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
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' )
>
>
> 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
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