EOQualifier - Query - "Not Exists" or "not in" query
"alisalimi74" <[email protected]> Fri, 25 Aug 2006 16:02:42 -0000
| Newsgroups | gmane.comp.web.webobjects.newbies |
|---|---|
| Message-ID | <[email protected]> |
Hi,
Anybody know how can I implement "not exists" part of my query in
EOQualifier?
I have 2 tables A and B. I want to say select * from A where A_ID not
in (select A_ID from B).
What can qualifier1 be?
EOQualifier secQual = new EOAndQualifier( new NSArray(new Object[]
{qualifier1}));
fetchSpec = new EOFetchSpecification("A", secQual, null);
fetchSpec.setRefreshesRefetchedObjects(true);
pickList = new NSMutableArray
editingContext.objectsWithFetchSpecification(fetchSpec));
Thanks
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/webobjects-newbies/
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/