My understanding is that the DG will sort numerically if the column contains true numbers (not strings that look like numbers).
Be sure you are placing a true number in the dataProvider item property. But to store the data formatted as money, it can't be a number, so... Another solution would be a custom sort function. Tracy ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of danielvlopes Sent: Tuesday, October 02, 2007 2:11 PM To: [email protected] Subject: [flexcoders] Re: Sort string like number in datagrid Some one? --- In [email protected] <mailto:flexcoders%40yahoogroups.com> , "danielvlopes" <[EMAIL PROTECTED]> wrote: > > Ola, I am with the following problem... > I have the field value in some tables of my DB, in flex I store values > in format 0000,00 (money) but when I return the stored items for my > datagrid and click header to sort it no right sorted because is string. > > I'm using amfphp to get values from PHP. > > If i use, decimal on mysql, i think php will cast this decimal to > string before send to flex. > > Which would be the best way to fix this problem? > > Thanks >
