Hi there,
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 =
Reply.q.ticket_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:
NOT(EXISTS(Select(INNERJOINOn(Reply, EmailAddress,
Reply.q.fromAddressID == EmailAddress.q.id), where=Outer(Ticket).q.id ==
Reply.q.ticketID)))
which gives:
NOT EXISTS (SELECT reply INNER JOIN email_address ON
(reply.from_address_id = email_address.id) FROM reply WHERE ticket.id =
reply.ticket_id)
SQLBuilder.select() doesn't take a "join" parameter. So is there anyway
to do this?
Thanks in advance,
Matt
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
