SF.net SVN: ledger-smb:[4794] trunk/LedgerSMB/Form.pm

[..hidden..]

Revision: 4794
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4794&view=rev
Author:   einhverfr
Date:     2012-05-28 06:39:00 +0000 (Mon, 28 May 2012)
Log Message:
-----------
Correcting obsolete detection logic

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

Modified: trunk/LedgerSMB/Form.pm
===================================================================
--- trunk/LedgerSMB/Form.pm	2012-05-28 05:38:34 UTC (rev 4793)
+++ trunk/LedgerSMB/Form.pm	2012-05-28 06:39:00 UTC (rev 4794)
@@ -2283,9 +2283,9 @@
     my $key;
 
     # now get the account numbers
-    $query = qq|SELECT accno, description, link
-				  FROM chart
-                  JOIN account USING id AND NOT obsolete
+    $query = qq|SELECT a.accno, a.description, a.link
+				  FROM chart a
+                  JOIN account ON a.id = account.id AND NOT account.obsolete
 				 WHERE link LIKE ?
 			  ORDER BY accno|;
 

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