Re: How to do a "SELECT DISTINCT"
Re: How to do a "SELECT DISTINCT"
- Subject: Re: How to do a "SELECT DISTINCT"
- From: Denis Stanton <email@hidden>
- Date: Wed, 23 Mar 2005 11:07:51 +1200
I think my answer below was hasty. I have used
fetchSpec.setUsesDistinct(true); but I use in the sequence below. Maybe it is not useful unless you are reading raw rows.
fs.setRawRowKeyPaths(new NSArray("id"));
fs.setFetchesRawRows(true);
fs.setUsesDistinct(true);
On Mar 23, 2005, at 10:28 AM, Denis Stanton wrote:
On Mar 23, 2005, at 9:03 AM, Sébastien Gruhier wrote:
Hi,
I would like to perform a "select distinct" on my database.
Actually I do a fecthSpecification like this
EOFetchSpecification fetchSpec = new EOFetchSpecification("Table",
new EOKeyValueQualifier("attribute",
EOQualifier.QualifierOperatorEqual,
new Integer(1)),
null);
fetchSpec.setUsesDistinct(true);
editingContext.objectsWithFetchSpecification(fetchSpec);
<x-tad-smaller>Denis Stanton
Orcon Internet Limited
(09) 480 9299
</x-tad-smaller><x-tad-smaller>http://www.orcon.net.nz
</x-tad-smaller><x-tad-smaller>
</x-tad-smaller>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
<x-tad-smaller>Denis Stanton
Orcon Internet Limited
(09) 480 9299
</x-tad-smaller><x-tad-smaller>http://www.orcon.net.nz
</x-tad-smaller><x-tad-smaller>
</x-tad-smaller>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden