Custom ORDER BY
Custom ORDER BY
- Subject: Custom ORDER BY
- From: Pascal Robert <email@hidden>
- Date: Mon, 13 Jan 2003 16:04:06 -0500
Hi list,
I'm try to use a custom ORDER BY so that the results are sorted in
French instead of ASCII.
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 ? WO 5.1.4, OS X
10.2.3, Oracle 9i (on True64), latest classes12.zip
_______________________________________________
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.