[Web-erp-svn] SF.net SVN: web-erp:[4978] trunk/SelectOrderItems.php

[<Ex...@us...>]

Revision: 4978
          http://web-erp.svn.sourceforge.net/web-erp/?rev=4978&view=rev
Author:   ExsonQu
Date:     2012-02-26 16:07:26 +0000 (Sun, 26 Feb 2012)
Log Message:
-----------
26/02/2012 Fixed bug that when set frequently sold items, there are sql errors which claimed that no group set for sum() function. Fixed by Exson

Modified Paths:
--------------
    trunk/SelectOrderItems.php

Modified: trunk/SelectOrderItems.php
===================================================================
--- trunk/SelectOrderItems.php	2012-02-26 15:59:37 UTC (rev 4977)
+++ trunk/SelectOrderItems.php	2012-02-26 16:07:26 UTC (rev 4978)
@@ -1501,8 +1501,7 @@
 // This code needs sorting out, but until then :
 				$ImageSource = _('No Image');
 // Find the quantity in stock at location
-				$QOHSQL = "SELECT sum(locstock.quantity) AS qoh,
-									stockmaster.decimalplaces
+				$QOHSQL = "SELECT sum(locstock.quantity) AS qoh
 							   FROM locstock INNER JOIN stockmaster
 							   ON locstock.stockid=stockmaster.stockid
 							   WHERE locstock.stockid='" .$myrow['stockid'] . "' AND

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