SF.net SVN: ledger-smb:[2240] trunk/sql/modules/Payment.sql

[..hidden..]

Revision: 2240
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2240&view=rev
Author:   aurynn_cmd
Date:     2008-08-07 20:11:08 +0000 (Thu, 07 Aug 2008)

Log Message:
-----------
Setting the select for payment page to order vendors by ascending.

Modified Paths:
--------------
    trunk/sql/modules/Payment.sql

Modified: trunk/sql/modules/Payment.sql
===================================================================
--- trunk/sql/modules/Payment.sql	2008-08-06 23:40:37 UTC (rev 2239)
+++ trunk/sql/modules/Payment.sql	2008-08-07 20:11:08 UTC (rev 2240)
@@ -269,7 +269,7 @@
 			(sum(p.due) > c.threshold
 			OR sum(case when a.batch_id = in_batch_id then 1
                                   else 0 END) > 0)
-        ORDER BY c.meta_number DESC
+        ORDER BY c.meta_number ASC
 	LOOP
 		RETURN NEXT payment_item;
 	END LOOP;


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