Of course I can. :) In a short term, I have to provide a web application with some JSP, where I simply have to present a list of persistent and manageable objects. The table might be big, and I would present sublists (each with a bounded cardinlity), with http links to jump to the prev/next sublist. The OFFSET and LIMIT parameters are then known from the URL (after some sanity checks).
Further, some Web-services will have to do the same kind of table listings, with attributes known from the request parameters. If it helps, I am pretty sure this application will use either MySQL, Postgresql or Apache-Derby as a DB backend. Thanks again. JFS 2008/3/16, Andrus Adamchik <[EMAIL PROTECTED]>: > > Specifying offset is not (yet) supported. Aside from SQLTemplate there > are various ways to solve it depending on your requirements. So can > you explain how do you know which OFFSET to use, maybe there is an > alternative solution... > > > Andrus > > > > On Mar 16, 2008, at 10:10 PM, Jean-François Smigielski wrote: > > Hello, list! > > > > I am wondering if and how it is possible to limit the result of a > > SelectQuery with Cayenne 3.0. > > > > For a user interface purpose, I want to be able to present only a > > subset of > > a select on a huge table. I already use the setFetchLimit(int) > > method to set > > a LIMIT clause, but I am unable to precisely tell the OFFSET at > > which my > > subset must start. I do not find how in the online Javadoc. > > > > Any help would be appreciated, thanks a lot! > > Best regards, > > > > -- > > JF Smigielski > > -- JF Smigielski
