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.

Thanks

Ryan
------------------------------------------------------------------------------
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
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
Wonder-disc mailing list
Wonder-disc@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wonder-disc