Fetching rows with a specific range
"Y. Dong" <[email protected]>
| Newsgroups | gmane.comp.web.webobjects.wonder-disc |
|---|---|
| Message-ID | <[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