Thanks for the beautiful solution. It works like a charm in conjunciton with "Select ... Limit startRow, pageSize" for getting the exact number of rows and "Select count(*) ..." for getting the size of the dataset.
It will take me a while more to understand the inner workings. But thanks again. Best regards, Yee -----Original Message----- From: Simon Kitching [mailto:[EMAIL PROTECTED] Sent: Monday, 28 November 2005 10:19 AM To: MyFaces Discussion Subject: Re: dataTable, t:dataScroller and large datasets Hi, For all those interested in this thread, I've come up with a solution that suits me, and have added it to a page on the wiki; see "WorkingWithLargeTables" in the HowTo section on the main page. Regards, Simon
