Re: [SQLObject] how to select objects with foreign keys that point to non existing rows?

sophana Tue, 31 Oct 2006 05:49:09 -0800

Oleg Broytmann a écrit :

On Tue, Oct 31, 2006 at 01:42:22PM +0100, sophana wrote:

Is there no way of selecting that without doing a python iteration?


   I've copied the code from a program that fixed a similar mistake.

In my case, it is object A which has a foreignKey to object B
And I delete some B instances.


   In SQL it should be something with NOT EXISTS, and SQLObject supports
EXISTS() and NOTEXISTS(), but I don't have such code.

Oleg.

Thanks for the pointer.
The solution was
A.select("A.bID is not null and not exists (select * from B where B.id=A.bID)")

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Re: [SQLObject] how to select objects with foreign keys that point to non existing rows?

Reply via email to