the DB relationship model is
http://i30.tinypic.com/jaz4wm.jpg - Nishant --- On Sun, 13/9/09, Nishant Neeraj <nneeraj...@yahoo.com> wrote: From: Nishant Neeraj <nneeraj...@yahoo.com> Subject: Sorting and Pagination in Many-to-Many relationship To: "Cayenne Mailing List" <user@cayenne.apache.org> Date: Sunday, 13 September, 2009, 2:25 PM 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 subscriptions. In the method, I iterate through the list and inflating Magzines (subscriptions.getMagzines()) and injecting SubscriptionType to magzine object. And then I return the list. This works fine. Now, I do not want to pull out the full list. Rather, I want do it page by page sort by say, MagzineName with page Size N. Not sure how to do it. Can some one give a hint? ThanksNishant Love Cricket? Check out live scores, photos, video highlights and more. Click here http://cricket.yahoo.com See the Web's breaking stories, chosen by people like you. Check out Yahoo! Buzz. http://in.buzz.yahoo.com/
