Re: Fetching rows with a specific range
Maik Musall <[email protected]>
| Newsgroups | gmane.comp.web.webobjects.wonder-disc |
|---|---|
| Message-ID | <[email protected]> |
Hi Ryan, have you tried EOFetchSpecification fspec = ... fspec.setFetchLimit( 10 ); using an EOSortOrdering? That should let the database pre-sort the result and stop after 10 rows returned. Maik Am 19.12.2012 um 14:38 schrieb Y. Dong <[email protected]>: > 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/wonder-disc ------------------------------------------------------------------------------ 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