Index: topia/src/java/org/codelutin/topia/persistence/PersistenceStorageJDBC.java
diff -u topia/src/java/org/codelutin/topia/persistence/PersistenceStorageJDBC.java:1.2 topia/src/java/org/codelutin/topia/persistence/PersistenceStorageJDBC.java:1.3
--- topia/src/java/org/codelutin/topia/persistence/PersistenceStorageJDBC.java:1.2	Fri Jul 22 16:52:46 2005
+++ topia/src/java/org/codelutin/topia/persistence/PersistenceStorageJDBC.java	Mon Jul 25 14:14:48 2005
@@ -23,9 +23,9 @@
  * Created: 20 juillet 2005 15:25:06 CEST
  *
  * @author Benjamin POUSSIN <poussin@codelutin.com>
- * @version $Revision: 1.2 $
+ * @version $Revision: 1.3 $
  *
- * Last update: $Date: 2005/07/22 16:52:46 $
+ * Last update: $Date: 2005/07/25 14:14:48 $
  * by : $Author: bpoussin $
  */
 
@@ -152,8 +152,9 @@
         "CREATE INDEX index_data_id ON data (id);");
         SQL_DEFAULT.put(SQL_CREATE_INDEX_DATA_DATE,
         "CREATE INDEX index_data_longdate ON data (longdate);");
+        // on tri sur la valeur abasolue puis sur la valeur reel, pour que les transactions arrive en premier dans les resultats
         SQL_DEFAULT.put(SQL_LOAD_HISTORY,
-        "SELECT * FROM management WHERE id=? AND ((longdate > 0 and longdate<=?) or longdate=?) order by abs(longdate) desc;");
+        "SELECT * FROM management WHERE id=? AND ((longdate > 0 and longdate<=?) or longdate=?) order by abs(longdate) desc, longdate;");
         SQL_DEFAULT.put(SQL_REMOVE_DATA,
         "DELETE data WHERE id=? and longdate=?;");
         SQL_DEFAULT.put(SQL_GET_ALL_ID,