[Web-erp-svn] SF.net SVN: web-erp:[7737] trunk

[<tu...@us...>]

Revision: 7737
          http://sourceforge.net/p/web-erp/reponame/7737
Author:   turbopt
Date:     2017-03-07 18:01:30 +0000 (Tue, 07 Mar 2017)
Log Message:
-----------
(by Tim in forums) BankAccounts.php: Add quotes to variable in query.

Modified Paths:
--------------
    trunk/BankAccounts.php
    trunk/doc/Change.log

Modified: trunk/BankAccounts.php
===================================================================
--- trunk/BankAccounts.php	2017-02-27 20:30:00 UTC (rev 7736)
+++ trunk/BankAccounts.php	2017-03-07 18:01:30 UTC (rev 7737)
@@ -404,7 +404,7 @@
 }
 
 if (isset($SelectedBankAccount)) {
-	$result = DB_query("SELECT invoice FROM bankaccounts where accountcode =" . $SelectedBankAccount );
+	$result = DB_query("SELECT invoice FROM bankaccounts where accountcode = '" . $SelectedBankAccount . "'" );
 	while ($myrow = DB_fetch_array($result)) {
 		if ($myrow['invoice']== 1) {
 			echo '<option selected="selected" value="1">' . _('Fall Back Default') . '</option>

Modified: trunk/doc/Change.log
===================================================================
--- trunk/doc/Change.log	2017-02-27 20:30:00 UTC (rev 7736)
+++ trunk/doc/Change.log	2017-03-07 18:01:30 UTC (rev 7737)
@@ -1,5 +1,6 @@
 webERP Change Log
 
+07/03/17 TurboPT: (by Tim in forums) BankAccounts.php: Add quotes to variable in query.
 27/02/17 TurboPT: SpecialOrder.php add identifier to delete link; DefineSpecialOrderClass.php remove the "&" with parameter to function remove_from_order().
 26/02/17 TurboPT: CopyBOM.php fixed insert SQL had duplicate digitals field
 14/1/17	Phil: CustomerReceipt now calculates payment discount based on percentages entered in payment methods