SF.net SVN: ledger-smb: [359] trunk/LedgerSMB/PriceMatrix.pm

[..hidden..]

Revision: 359
          http://svn.sourceforge.net/ledger-smb/?rev=359&view=rev
Author:   tetragon
Date:     2006-10-28 11:01:47 -0700 (Sat, 28 Oct 2006)

Log Message:
-----------
Fix spelling of query column names

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

Modified: trunk/LedgerSMB/PriceMatrix.pm
===================================================================
--- trunk/LedgerSMB/PriceMatrix.pm	2006-10-28 18:00:37 UTC (rev 358)
+++ trunk/LedgerSMB/PriceMatrix.pm	2006-10-28 18:01:47 UTC (rev 359)
@@ -59,7 +59,7 @@
 
     			SELECT p.parts_id, p.customer_id, p.pricegroup_id, 
 				p.pricebreak, p.sellprice, p.validfrom,
-				p.valid_to, p.curr, g.pricegroup
+				p.validto, p.curr, g.pricegroup
 			FROM partscustomer p
 			LEFT JOIN pricegroup g ON (g.id = p.pricegroup_id)
 			WHERE p.parts_id = ?
@@ -69,7 +69,7 @@
 
     			SELECT p.parts_id, p.customer_id, p.pricegroup_id, 
 				p.pricebreak, p.sellprice, p.validfrom,
-				p.valid_to, p.curr, g.pricegroup
+				p.validto, p.curr, g.pricegroup
 			FROM partscustomer p
 			LEFT JOIN pricegroup g ON (g.id = p.pricegroup_id)
 			JOIN customer c ON (c.pricegroup_id = g.id)
@@ -80,8 +80,9 @@
 
     			SELECT p.parts_id, p.customer_id, p.pricegroup_id, 
 				p.pricebreak, p.sellprice, p.validfrom,
-				p.valid_to, p.curr, g.pricegroup
+				p.validto, p.curr, g.pricegroup
 			FROM partscustomer p
+			LEFT JOIN pricegroup g ON (g.id = p.pricegroup_id)
 			WHERE p.customer_id = 0
 			AND p.pricegroup_id = 0
 			AND p.parts_id = ?


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