Datagrid sort issue with paging

[halostars]

Hello,

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?

[Jorge Solis]

Are you loading all records, or just a portion? (using pageable recordset or just an sql LIMIT)

Jorge

[halostars]

I am using a Pageable Recordset and I set the delivery mode to 'page' in the result handler -- I pretty much followed the example on amfphp.org.

[Ronald Wernecke]

In this case the grid cannot sort, because it does not have all the records.
But you can write a function calling the database again to make the database sort the records in the way the user asks it to and deliver then pagable records in the right order.
This means another roundtrip to the server, but is propably much more responsive to your user than loading all the records to make the grid do the sort.