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

[..hidden..]

Revision: 2227
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2227&view=rev
Author:   aurynn_cmd
Date:     2008-07-31 19:04:59 +0000 (Thu, 31 Jul 2008)

Log Message:
-----------
Add the ORDER BY to payment_get_all_contact_invoices, to correctly sort by meta_number/vendor_number.

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

Modified: trunk/sql/modules/Payment.sql
===================================================================
--- trunk/sql/modules/Payment.sql	2008-07-31 18:38:43 UTC (rev 2226)
+++ trunk/sql/modules/Payment.sql	2008-07-31 19:04:59 UTC (rev 2227)
@@ -269,6 +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
 	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.