amfphp sort datagrid problem

The tutorial works very well except for one issue with the header sorting. The usual 'patch' applied on datagrids for numeric sorting won't work here because in fact DataProvider.sortItemsBy and RecordSet.sortItemsBy has a different signature. That is why it was working when the dataProvider was a vanilla array (in the LoadVars case) and not in the RecordSet case. This is not an amfphp errorbut rather an inconsistency in MM's v2 API. That one took me a good hour to track down.

Here's the fix:

in onGetScores:

      scores_dg.getColumnAt(1).sortOnHeaderRelease = false;

      scores_dg.addEventListener("headerRelease", Delegate.create(this, sortNumerically));

Then the sortNumerically function:

function sortNumerically(evtObj)
{
    var i = evtObj.columnIndex;
    var col = scores_dg.getColumnAt(i);
    if(i == 1)
    {
        //Sort this column numerically
        var dir = col.headerCell.asc ? 2 : 0;
        scores_dg.dataProvider.sortItemsBy(col.columnName, null, dir | Array.NUMERIC );
        col.headerCell.asc = !col.headerCell.asc;
    }
}

Here is a zip with the fla, the php class and the sql:

www.5etdemi.com/uploads/highscores.zip

I remember a Technote saying that to solve this issue you had to use all sorts of dataBinding voodoo, when in fact probably all it did is convert the RecordSet object to a vanilla array.

Note: when using the mx v2 components, Array.prototype is mixed in with mx.controls.listclasses.DataProvider and therefore acquires a whole bunch of new methods. It makes arrays dispatch events and do all sorts of voodoo. That is one of the reasons why apps with v2 components are slowed down. Mixins are kind of cool (EventDispatcher is great) but mixing-in the prototype of one of the core objects with all sorts of stuff should be considered evil.