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

[..hidden..]

Revision: 436
          http://svn.sourceforge.net/ledger-smb/?rev=436&view=rev
Author:   tetragon
Date:     2006-10-31 16:01:28 -0800 (Tue, 31 Oct 2006)

Log Message:
-----------
Convert query to using new defaults table form

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

Modified: trunk/LedgerSMB/PriceMatrix.pm
===================================================================
--- trunk/LedgerSMB/PriceMatrix.pm	2006-10-31 23:52:23 UTC (rev 435)
+++ trunk/LedgerSMB/PriceMatrix.pm	2006-11-01 00:01:28 UTC (rev 436)
@@ -50,7 +50,8 @@
 			SELECT p.id AS parts_id, 0 AS customer_id, 
 				0 AS pricegroup_id, 0 AS pricebreak, 
 				p.sellprice, NULL AS validfrom, NULL AS validto,
-				(SELECT substr(curr,1,3) FROM defaults) AS curr,
+				(SELECT substr(value,1,3) FROM defaults WHERE 
+					setting_key = 'curr') AS curr,
 			        '' AS pricegroup
 	     		FROM parts p
 			WHERE p.id = ?


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