Re: Sorting and Pagination in Many-to-Many relationship

the DB relationship model is      http://i30.tinypic.com/jaz4wm.jpg - Nishant --- On Sun, 13/9/09, Nishant Neeraj wrote: From: Nishant Neeraj Subject: Sorting and Pagination in Many-to-Many relationship To: "Cayenne Mailing List" Date: Sunday, 13 September, 2009, 2:25 PM I am having problem

Sorting and Pagination in Many-to-Many relationship

I am having problem in sorting and paginating  many to many relationship objects. Here is the DB relationship model.  http://i30.tinypic.com/jaz4wm.jpgI want to do Readers.getMagzines() that returns paginated resultset of page size, N. I write a Readers.getMagzine() Method that pulls out List of