You can specify the SQL for a fetch by adding a "hint" the the fetchSpec's userInfo with the SQL statement you want to use.  Search the web for the syntax.

On Wednesday, December 19, 2012, Y. Dong wrote:
Hi there,

I would do something like SELECT * FROM  ( SELECT * FROM Articles ORDER BY createdTime) WHERE ROWNUM<=10;

Semantically it means please give me the oldest 10 articles by createdTime. Any idea how to express this in terms of webobjects. ERXFetchSpecification alone doesn't seem adequate.


LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
Wonder-disc mailing list