That is my best bet if the solution I am looking for isn't possible. Hopefully I will be able to pass the sort columns back to the query for sorting...
Currently I'm using a pagableArrayCollection. The RO calls the CFC, which executes the query. In the result event, the event.result is bound to a "holding" ArrayCollection, then a pagablearraycollection is created from the "holding" source.
private function getData_result(event:ResultEvent):void {
acHold = event.result as ArrayCollection;
acData = new PagableArrayCollection(acHold.source);
}
The dataprovider is acData.
What I want to do is bind in segments, breaking the script segment into chunks so that it will not timeout. Now I'm wondering, is it timing out on binding acHold, acData, or displaying the datagrid.
As is, the app attempts to load all of the data at once, but only 100 records are "displayed" in the datagrid, even though all of the data is actually bound.