Re: Custom ORDER BY
Re: Custom ORDER BY
- Subject: Re: Custom ORDER BY
- From: Art Isbell <email@hidden>
- Date: Mon, 13 Jan 2003 12:26:09 -1000
On Monday, January 13, 2003, at 11:04 AM, Pascal Robert wrote:
In pure SQL, I just have to say:
ORDER BY NLSSORT(myColumn, 'NLS_SORT = FRENCH')
and it works. Now the WO part: when I create a new Fetch
Specification in my EOModel, I go to the "SQL" tab, I choose "Use Raw
SQL Expression" and I put my custom ORDER BY there. But when I save
the EOModel, EOModeler just remove the ORDER BY clause :-/ An
EOSQLQualifier just let me modify the WHERE clause, not the ORDER BY,
so I'm lost.
Any other solutions beside using a stored procedure ?
If raw rows are sufficient, see EOUtilities.rawRowsForSQL
If you want to fetch objects into an editing context, see the method
description for EOFetchSpecification's setHints(). The hints
dictionary should contain a key of
EODatabaseContext.CustomQueryExpressionHintKey with a value of the SQL
string for the query. See the "Using a Custom Query" section of the
EODatabaseContext class description for restrictions on the SQL that
can be specified.
Art
http://homepage.mac.com/aisbell/
_______________________________________________
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.