Re: Fetching rows with a specific range
John Huss <[email protected]>
| Newsgroups | gmane.comp.web.webobjects.wonder-disc |
|---|---|
| Message-ID | <CAOUwSGt3s+g-PwJxz4n4G=o+VV7-FZVXvRxCxzLfHgJMSb=0eg@mail.gmail.com> |
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 > [email protected] <javascript:;> > 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 _______________________________________________ Wonder-disc mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/wonder-disc