List:MySQL and .NET« Previous MessageNext Message »
From:Reggie Burnett Date:December 10 2004 4:19pm
Subject:RE: MySqlDateTime in Datatables sorting by Text, not Date.
View as plain text  
Pushed.

> -----Original Message-----
> From: Barry Zubel [mailto:barry@stripped]
> Sent: Friday, December 10, 2004 2:35 AM
> To: dotnet@stripped
> Subject: RE: MySqlDateTime in Datatables sorting by Text, not Date.
> 
> Thanks Reggie - mysql.bkbits.net isn't showing the latest build (certainly
> from their web-based system) so can you push that out so that I can test
> it
> off :D
> 
> Thanks buddy!
> 
> B.
> 
> -----Original Message-----
> From: Reggie Burnett [mailto:reggie@stripped]
> Sent: 10 December 2004 03:27
> To: 'Barry Zubel'; dotnet@stripped
> Subject: RE: MySqlDateTime in Datatables sorting by Text, not Date.
> 
> 
> I fixed this and marked the bug report closed.  Thanks!
> 
> > -----Original Message-----
> > From: Barry Zubel [mailto:barry@stripped]
> > Sent: Monday, December 06, 2004 3:43 AM
> > To: dotnet@stripped
> > Subject: MySqlDateTime in Datatables sorting by Text, not Date.
> >
> > Okay, an odd one that I've probably managed to screw up myself (tee
> > hee).
> >
> > The following extracted code should reproduce the problem: (parts
> > removed for brevity)
> >
> > sSql = "SELECT DATECOLUMN, SOMEOTHERFIELD FROM YOURTABLE ORDER BY
> > SOMEOTHERFIELD ASC" (where DATECOLUMN is a DATE or DATETIME Mysql
> > Type, SOMEOTHERFIELD can be
> > anything)
> >
> > ...
> > (instantiate connector, command, and dataadapter and fill datatable
> > with
> > results)
> > ...
> >
> > myDataGrid.DataSource = myDataTable
> >
> >
> > Now the important thing is to have source data that spans several
> > months. When the datagrid is displayed, simply click on the DATECOLUMN
> > column header to resort by date ascending or descending.
> >
> > I have found that the DataTable actually seems to text-sort, instead
> > of date-sort.
> >
> > For example, The dates:
> >
> > 01/10/2004
> > 01/11/2004
> > 02/10/2004
> > 02/11/2004
> >
> > Will appear IN THAT ORDER, instead of the more logical (and expected):
> >
> > 01/10/2004
> > 02/10/2004
> > 01/11/2004
> > 02/11/2004
> >
> > (Based on the UK date format, which is DD/MM/YYYY)
> >
> > This has occurred since Beta 2, (I believe - I've not confirmed this
> > yet) but I'd like someone else to verify that this is the case before
> > I post something to the mysql bugzilla.
> >
> > Ta muchly!
> >
> > B.
> >
> >
> >
> > --
> > MySQL on .NET Mailing List
> > For list archives: http://lists.mysql.com/dotnet
> > To unsubscribe:    http://lists.mysql.com/dotnet?unsub=1
> 
> 
> 
> --
> MySQL on .NET Mailing List
> For list archives: http://lists.mysql.com/dotnet
> To unsubscribe:    http://lists.mysql.com/dotnet?unsub=1

Thread
MySqlDateTime in Datatables sorting by Text, not Date.Barry Zubel6 Dec
  • RE: MySqlDateTime in Datatables sorting by Text, not Date.Reggie Burnett10 Dec
    • RE: MySqlDateTime in Datatables sorting by Text, not Date.Barry Zubel10 Dec
      • Totally off topic -- Using Bitkeeper with SVGuy Platt10 Dec
        • RE: Totally off topic -- Using Bitkeeper with SVReggie Burnett10 Dec
      • RE: MySqlDateTime in Datatables sorting by Text, not Date.Reggie Burnett10 Dec