[SQLObject] overriden column trouble

2007-06-11 Thread Stanko Petrovic
Hi I am using sqlobject-0.7.7a_r2689-py2.4.egg with sql server and I stumble on this problem this what I have class Testadd(so.SQLObject): class sqlmeta: style = so.MixedCaseStyle(longID=True) table = 'testadd' Name = so.StringCol() BufferSize = so.FloatCol( default = 0.0

Re: [SQLObject] LEFTJOINOn and InheritableSQLObject weirdness

2007-06-11 Thread Leandro Lucarella
Daniel Nogradi, el 10 de junio a las 20:52 me escribiste: > > > > > sqlobject.dberrors.OperationalError: no such column: animal.cage_id > > > > > > > >But there is "cage_id" columnm in the "animal" table > > > > > > Well, that's exactly the problem :) > > > >Are you sure this part of the pr

Re: [SQLObject] Selecting from multiple tables/classes.

2007-06-11 Thread Nick Murdoch
Oleg Broytmann wrote: > On Fri, Jun 08, 2007 at 06:11:11PM +0100, Nick Murdoch wrote: >> The relevant part there is SELECT * from (SELECT * FROM vip_comp_details >> UNION SELECT * FROM contact_details ), I guess. > >UNION is meaningless for high-level SQLObject API. The only way to do > UNION