I am using amfphp to query my database, return a recordset, and assign it to my datagrid. The recordset doesn't get displayed all at once, but in increments of 10 as the user scrolls down. My problem is, when I click on the datagrid's column headers BEFORE all the results are in the database, the datagrid won't sort. It only sorts after the user has scrolled down all the way and all records are in.
This is a problem because potentially there will be 100's of records, and I don't want to force the user to load all of them to be able to sort through them. So, anyone have any suggestions? I think that the way paging is working, the recordset's contents are just temporary until all records are in. So I am worried that if I sort on the temporary recordset and then the user gets a new page of data it will replace the sort. Anyone dealt with this before?