EOQualifier - Query from database - "not in" or "not exists"
Ali Salimi <[email protected]> Fri, 25 Aug 2006 14:51:19 -0700 (PDT)
| 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
---------------------------------
All-new Yahoo! Mail - Fire up a more powerful email and get things done faster.