Re: [SQLObject] a complex query question

2009-03-12 Thread Frank Wagner
Hi Daniel Hi Oleg, I don“t know how to realize this with union but i think this should do it # plain sql would be sth like this (untested) select * from comment where (object='zoo' and object_id=?) or (object='cage' and object_id in (select id from cage where zoo=?)) or (object='animal' and obje

Re: [SQLObject] a complex query question

2009-03-12 Thread Oleg Broytmann
On Wed, Mar 11, 2009 at 06:52:17PM -0700, Daniel Fetchinson wrote: > Unfortunately I haven't found > working examples of SQLBuilder + UNION constructions so far, if I > don't manage to get it right I'll probably come back :) If you manage to get it right please come back anyway and show us an e