What is the workaround? The sortCompareFunction does not seem to be reasonable, since a version needs to be written for each column in each grid.
This seems like a serious shortcoming... Paul --- In flexcoders@yahoogroups.com, "Alex Harui" <[EMAIL PROTECTED]> wrote: > > THe default sort code can't handle null as it isn't a date or number > > ________________________________ > > From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On > Behalf Of aceoohay > Sent: Thursday, November 29, 2007 8:49 PM > To: flexcoders@yahoogroups.com > Subject: [flexcoders] Re: Sorting problem on date and numbers with null > values, I think > > > > When I said no values returned from the DB, I meant that the grid is > populated with some records that have the values in the number/date > column, and others that don't. > > Paul > --- In flexcoders@yahoogroups.com <mailto:flexcoders% 40yahoogroups.com> > , "aceoohay" <pauls@> wrote: > > > > I running flexbuilder 2.0.1, AS 3. > > > > I have a number of datagrids. In two of my grids I have date and > > number fields that sometimes have no values returned from the DB. > > When I click the heading on these columns to sort Ascending they > work > > fine. When I click a second time (descending) I get the following > > error; > > > > =============================================================== > > Error: Cannot determine comparator for SortField with > > name ''MyNumberDataField''. > > at mx.collections::SortField/::nullCompare() > > at > > > mx.collections::SortField/http://www.adobe.com/2006/flex/mx/internal: : > <http://www.adobe.com/2006/flex/mx/internal::> > > internalCompare() > > at mx.collections::Sort/::internalCompare() > > at mx.collections::Sort/findItem() > > at mx.collections::ListCollectionView/getItemIndex() > > at ::ListCollectionViewCursor/::collectionEventHandler() > > at > > > flash.events::EventDispatcher/flash.events:EventDispatcher::dispatchE v > > entFunction() > > at flash.events::EventDispatcher/dispatchEvent() > > at mx.collections::ListCollectionView/dispatchEvent() > > at mx.collections::ListCollectionView/::internalRefresh() > > at mx.collections::ListCollectionView/refresh() > > at mx.controls::DataGrid/::sortByColumn() > > at mx.controls::DataGrid/::headerReleaseHandler() > > at > > > flash.events::EventDispatcher/flash.events:EventDispatcher::dispatchE v > > entFunction() > > at flash.events::EventDispatcher/dispatchEvent() > > at mx.core::UIComponent/dispatchEvent() > > at mx.controls::DataGrid/mx.controls:DataGrid::mouseUpHandler > > () > > =============================================================== > > > > I am not using a sort compare function anywhere. I have other text > > type fields with nulls that seem to sort correctly. > > > > This seems like a bug. > > > > Any ideas? > > > > Paul > > >