From: Matt Doran <matt.doran@pa...> - 2006-04-16 15:18:53
I'm very new to SQLObject, and I'm trying to create a query like the
following using sqlbuilder. I'm using SQLObject 0.7.1. Note that I've
removed some of the where clause from the subselect for simplicity.
select * from Tickets where not exists (select * from Reply inner
join Reply.from_address_id ==EmailAddress.id where Ticket.q.id =
However I'm having trouble building the join in the subselect. It seems
that joins aren't supported. Building the subselect portion I've tried:
Reply.q.fromAddressID == EmailAddress.q.id), where=Outer(Ticket).q.id ==
NOT EXISTS (SELECT reply INNER JOIN email_address ON
(reply.from_address_id = email_address.id) FROM reply WHERE ticket.id =
SQLBuilder.select() doesn't take a "join" parameter. So is there anyway
to do this?
Thanks in advance,
On Mon, Apr 17, 2006 at 01:18:48AM +1000, Matt Doran wrote:
JOINs work only with .select(), not with sqlbuilder.Select().
> SQLBuilder.select() doesn't take a "join" parameter. So is there anyway
> to do this?
Oleg Broytmann http://phd.pp.ru/ phd@...
Programmers don't die, they just GOSUB without RETURN.
Hehe. Thanks Oleg.
Oleg Broytmann wrote:
> On Mon, Apr 17, 2006 at 01:18:48AM +1000, Matt Doran wrote:
> JOINs work only with .select(), not with sqlbuilder.Select().
>> SQLBuilder.select() doesn't take a "join" parameter. So is there anyway
>> to do this?
> Patch sqlbuilder.
Get latest updates about Open Source Projects, Conferences and News.