I have seen many threads here and also on TheSeverSide.com that discuss strategies for paging the result set for large search operations. But it did not mention how to handle sorting with paging. Any body has any good ideas about implementing paging with sorting? thanks
No doubt, but it is not necessary to post it on every previous paging question asked. Once will do just fine, and it can be posted as an answer to future questions of the same kind. Goodness knows it gets asked enough. [ June 05, 2004: Message edited by: Bear Bibeault ]
As part of the FormattedDataSet codeline I have an array Sorter if that is what you wish to sort. I use it to perform the clickable sorting that you see on the live demo homepage at http://www.fdsapi.com.
In general it works like similarly to an order by clause on a select statement, but for arrays instead (i.e. order by col1 desc, col2 asc). You can also provide your own Compare logic. The javadocs are also available at the link.