Re: sort orderings
Re: sort orderings
- Subject: Re: sort orderings
- From: Francis Labrie <email@hidden>
- Date: Thu, 29 Apr 2004 09:46:16 -0400
Hi,
John Spicer wrote:
I'm building some sorts. Some of the fields are int and some are
string. The int sorts work fine. The strings don't. This is the code
I'm using:
sortOrderings = new NSMutableArray();
EOSortOrdering sortOrdering;
sortOrdering = new EOSortOrdering("eventType", EOSortOrdering.
CompareDescending);
sortOrderings.addObject(sortOrdering);
where eventType is a Java string. I've tried also
CompareCaseInsensitiveAscending and CompareAscending as well.
The records seem to be in a random order - it does not even correspond
to the order in the database table.
If I take the sort out entirely, the records do display in the order
they are listed in the table, so I know that the sort is having SOME
effect. Just the wrong one.
Any ideas or is there something I've missed here?
I strongly suspect a bad collation or character set usage on the
database side. Which kind of Database Managament System are you using?
What is the collation type and the character set used in your database?
--
Francis Labrie
Saint-Bruno-de-Montarville, Quebec, Canada
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.