Re: [SQLObject] using foreign keys in select has and incongruent behaviour

2006-01-19 Thread Pau Aliagas
On Thu, 19 Jan 2006, Justin Azoff wrote: Pau Aliagas wrote: I have two tables: class handset_brand(SQLObject): brand = StringCol(alternateID = True, length = 50) handsets = SQLMultipleJoin('handset') class handset(SQLObject): handset_brand = ForeignKey('handset_brand'

Re: [SQLObject] using foreign keys in select has and incongruent behaviour

2006-01-19 Thread Justin Azoff
Pau Aliagas wrote: I have two tables: class handset_brand(SQLObject): brand = StringCol(alternateID = True, length = 50) handsets = SQLMultipleJoin('handset') class handset(SQLObject): handset_brand = ForeignKey('handset_brand') model = StringCol(alternateID = T

Re: [SQLObject] using foreign keys in select has and incongruent behaviour

2006-01-19 Thread Pau Aliagas
On Thu, 19 Jan 2006, Pau Aliagas wrote: Sorry for folowing up myself, there are some mistakes, the question still remains. I should have used the dotq syntax in select! I have two tables: class handset_brand(SQLObject): brand = StringCol(alternateID = True, length = 50) handse

[SQLObject] using foreign keys in select has and incongruent behaviour

2006-01-19 Thread Pau Aliagas
I have two tables: class handset_brand(SQLObject): brand = StringCol(alternateID = True, length = 50) handsets = SQLMultipleJoin('handset') class handset(SQLObject): handset_brand = ForeignKey('handset_brand') model = StringCol(alternateID = True, length = 25)