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
