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

[<dai...@us...>]

Revision: 4105
          http://web-erp.svn.sourceforge.net/web-erp/?rev=4105&view=rev
Author:   daintree
Date:     2010-10-23 04:04:32 +0000 (Sat, 23 Oct 2010)

Log Message:
-----------
PurchData.php search by supplier name SQL concatenation stuffed now repaired

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

Modified: trunk/PurchData.php
===================================================================
--- trunk/PurchData.php	2010-10-22 04:40:14 UTC (rev 4104)
+++ trunk/PurchData.php	2010-10-23 04:04:32 UTC (rev 4105)
@@ -257,7 +257,7 @@
 					suppliers.address1,
 					suppliers.address2,
 					suppliers.address3
-					FROM suppliers WHERE suppliers.suppname LIKE . ".$SearchString;
+					FROM suppliers WHERE suppliers.suppname " . LIKE ."'" . $SearchString . "'";
     } elseif (strlen($_POST['SupplierCode']) > 0) {
         $SQL = "SELECT suppliers.supplierid,
 				suppliers.suppname,

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-10-22 04:40:14 UTC (rev 4104)
+++ trunk/doc/Change.log.html	2010-10-23 04:04:32 UTC (rev 4105)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>23/10/10 Phil: PurchData.php - search by name failed concatenation of SQL stuffed now repaired.
 <p>20/10/10 Paul: MiscFunctions.js - Bug #3060329. Correct condition check. [allows the calendar to start with the textbox's date]</p>
 <p>18/10/10 Paul: WorkOrderReceive.php - Bug #3023776. Applied anonymous contribution.</p>
 <p>16/10/10 Phil: SupplierInvocie.php fixed for mix up with commits - now shipment charges added correctly and contract charges also


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