SF.net SVN: ledger-smb:[3202] trunk/LedgerSMB/CA.pm

[..hidden..]

Revision: 3202
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3202&view=rev
Author:   ehuelsmann
Date:     2011-06-08 20:09:16 +0000 (Wed, 08 Jun 2011)

Log Message:
-----------
When header and account use the same number, order the header before
the account, always.

 * LedgerSMB/CA.pm (all_accounts): Add ordering on inline query
      for account type -- ordering was already done by account.

Modified Paths:
--------------
    trunk/LedgerSMB/CA.pm

Modified: trunk/LedgerSMB/CA.pm
===================================================================
--- trunk/LedgerSMB/CA.pm	2011-06-08 20:04:39 UTC (rev 3201)
+++ trunk/LedgerSMB/CA.pm	2011-06-08 20:09:16 UTC (rev 3202)
@@ -90,7 +90,7 @@
 		    SELECT c.id, c.accno, c.description, c.charttype, 
 		           c.gifi_accno, c.category, c.link
 		      FROM chart c
-		  ORDER BY accno|;
+		  ORDER BY accno, c.charttype DESC|;
 
     $sth = $dbh->prepare($query);
     $sth->execute || $form->dberror($query);


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.