I just checked in the stuff for limiting the results.
You use Criteria.setLimit() to limit the number of rows returned, and
Criteria.setOffset() to change the starting row returned.
If this is supported natively, the native sql to do this will be added
to the query, otherwise, the resultset will be limited at the client.
Postgres and MySQL both support limit and offset natively.
Sybase & MS SQL/Server support limit but not offset natively.
I didn't know what the deal was with the other DB's, so I didn't add
anything for it.
I only tested it with Postgres, but I put in code for Sybase and MySQL.
Please test these.
-Nissim
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
