[Weberp-cvs] SF.net SVN: web-erp:[3773] trunk

[<tim...@us...>]

Revision: 3773
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3773&view=rev
Author:   tim_schofield
Date:     2010-09-24 18:18:59 +0000 (Fri, 24 Sep 2010)

Log Message:
-----------
SQL quoting corrections

Modified Paths:
--------------
    trunk/SelectProduct.php
    trunk/doc/Change.log.html

Modified: trunk/SelectProduct.php
===================================================================
--- trunk/SelectProduct.php	2010-09-24 18:12:20 UTC (rev 3772)
+++ trunk/SelectProduct.php	2010-09-24 18:18:59 UTC (rev 3773)
@@ -198,7 +198,7 @@
 		$PropValResult = DB_query("SELECT value
 							FROM stockitemproperties
 					WHERE stockid='" . $StockID . "'
-					AND stkcatpropid =" . $PropertyRow['stkcatpropid'], $db);
+					AND stkcatpropid ='" . $PropertyRow['stkcatpropid']."'", $db);
 		$PropValRow = DB_fetch_row($PropValResult);
 		$PropertyValue = $PropValRow[0];
 		echo '<tr><th align="right">' . $PropertyRow['label'] . ':</th>';

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-09-24 18:12:20 UTC (rev 3772)
+++ trunk/doc/Change.log.html	2010-09-24 18:18:59 UTC (rev 3773)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>24/09/10 Tim: SelectProduct.php - SQL quoting corrections</p>
 <p>24/09/10 Tim: SelectOrderItems.php - SQL quoting corrections</p>
 <p>24/09/10 Tim: SelectGLAccount.php - SQL quoting corrections and layout changes and improvements and bug fixes</p>
 <p>24/09/10 Tim: SelectCustomer.php - Layout changes and improvements and bug fixes</p>


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