diff options
| author | aurynn_cmd <aurynn_cmd@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-08-07 20:11:08 +0000 |
|---|---|---|
| committer | aurynn_cmd <aurynn_cmd@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-08-07 20:11:08 +0000 |
| commit | 168f6163adc860f2a476f683397b153552bfe976 (patch) | |
| tree | 91a2d932b2dfa50f0099c645daa509b6a3a6840e | |
| parent | f66f20e6db3f936e8c93b79593a08acae2c438ce (diff) | |
Setting the select for payment page to order vendors by ascending.
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2240 4979c152-3d1c-0410-bac9-87ea11338e46
| -rw-r--r-- | sql/modules/Payment.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/modules/Payment.sql b/sql/modules/Payment.sql index 1af67e9b..2a7e6e56 100644 --- a/sql/modules/Payment.sql +++ b/sql/modules/Payment.sql @@ -269,7 +269,7 @@ BEGIN (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; |