[libreoffice-users] Re: Database sort problem

Le 19/01/13 17:59, Ian Whitfield a écrit :

Hi Ian,

> Message No             Date
> 149                        01/01/13
>  58                         02/01/13
> 150                        02/01/13
> 225                        02/01/13
> 261                        07/01/13
> 307                        18/01/13
> 148                        18/12/12  *
> 260                        18/12/12  *
> 318                        19/01/13
> 319                        19/01/13
> 306                        24/10/12  *

Give us the data that you have in the underlying database table, rather
than that which LO displays, as this may/may not be a bug in the form
control itself, or in some other part of the LO code, as Girvin mentions.

To do this, use the mysql command line interface from the console :

SELECT "Message No", "Date" from whatevermytableiscalled, ORDER BY "Date"

You didn't say, but if you are using the mysql function DATE_FORMAT to
format your dates in a particular way, then you will probably encounter
this :

http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/mysql_dateformat_function_and_order_by.php

That might account for the behaviour you are seeing.


Alex





-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted