Re: Cayenne 3.0M3 : select query with LIMIT and OFFSET clauses

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Sun Mar 16 2008 - 17:01:18 EDT

  • Next message: Andrus Adamchik: "Re: Pb to cast Expression to ejbql string"

    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

    This archive was generated by hypermail 2.0.0 : Sun Mar 16 2008 - 17:01:49 EDT