I've created an XSL that reads in XML data and transforms it successfully. I have introduced sorting which is working perfectly, then I added pagination which works but when they are both used together the results aren't exactly what I want.
Say I have 12 records that match the criteria of the xsl, If I limit the page size to 5 records and sort by price descending then it sorts the first page of results but doesn't necessarily put the most expensive of the 12 at the top, just the most expensive on that page of results. On the other 2 pages there could be more expensive ones.
How do I make this so that if I sort by price descending it sorts the records then paginates. so that the order is correct, and then the order is maintained as they scroll through the pages.
I can add my XSL if you would like to see what I am doing currently.