LIMIT and OFFSET?

From: Jeff de Vries (jdevrie..frog.com)
Date: Sat Jul 23 2005 - 05:05:23 EDT

  • Next message: Adrian Wiesmann: "Re: Question Concerning XML - Was: M5 is out"

    I'm new to Cayenne and have just started looking at using it as a
    replacement for a bunch of JDBC code. The existing code is using SQL
    LIMIT and OFFSET clauses (with an appropriate ORDER BY clause in place)
    to step though groups of records incrementally for display as web
    pages. I think I've found the Cayenne way of doing LIMIT
    (setFetchLimit?), but I can't seem to find the equivalent of OFFSET.
    The underlying database is PostgreSQL 8.

    Thanks,
    Jeff

    This archive was generated by hypermail 2.0.0 : Sat Jul 23 2005 - 05:05:42 EDT