From 13b44be1961be124c44ecc6fccfc4d5b73ed516f Mon Sep 17 00:00:00 2001 From: tetragon Date: Sat, 28 Oct 2006 18:01:47 +0000 Subject: Fix spelling of query column names git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@359 4979c152-3d1c-0410-bac9-87ea11338e46 --- LedgerSMB/PriceMatrix.pm | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) (limited to 'LedgerSMB') diff --git a/LedgerSMB/PriceMatrix.pm b/LedgerSMB/PriceMatrix.pm index a2de4baf..0a92562c 100644 --- a/LedgerSMB/PriceMatrix.pm +++ b/LedgerSMB/PriceMatrix.pm @@ -59,7 +59,7 @@ sub price_matrix_query { 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 @@ sub price_matrix_query { 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 @@ sub price_matrix_query { 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 = ? -- cgit v1.2.3