SF.net SVN: ledger-smb:[3186] trunk/LedgerSMB/OE.pm

[..hidden..]

Revision: 3186
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3186&view=rev
Author:   einhverfr
Date:     2011-05-27 03:35:19 +0000 (Fri, 27 May 2011)

Log Message:
-----------
Patch 2971073

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

Modified: trunk/LedgerSMB/OE.pm
===================================================================
--- trunk/LedgerSMB/OE.pm	2011-05-27 03:25:05 UTC (rev 3185)
+++ trunk/LedgerSMB/OE.pm	2011-05-27 03:35:19 UTC (rev 3186)
@@ -2254,9 +2254,9 @@
 
         $query = qq|
 			SELECT pv.partnumber, pv.leadtime, pv.lastcost, pv.curr,
-				pv.vendor_id, v.name
+				v.id as vendor_id, v.name
 			FROM partsvendor pv
-			JOIN vendor v ON (v.id = pv.vendor_id)
+			JOIN vendor v ON (v.id = pv.credit_id)
 			WHERE pv.parts_id = ?|;
         $sth = $dbh->prepare($query) || $form->dberror($query);
 


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