[Weberp-svn] SF.net SVN: weberp:[4197] trunk

[<sot...@us...>]

Revision: 4197
          http://weberp.svn.sourceforge.net/weberp/?rev=4197&view=rev
Author:   sotandeka
Date:     2011-01-09 12:53:51 +0000 (Sun, 09 Jan 2011)

Log Message:
-----------
Correct the quotes in SQL literals

Modified Paths:
--------------
    trunk/EDIMessageFormat.php
    trunk/EDIProcessOrders.php
    trunk/EDISendInvoices.php
    trunk/ExchangeRateTrend.php

Modified: trunk/EDIMessageFormat.php
===================================================================
--- trunk/EDIMessageFormat.php	2011-01-09 12:36:52 UTC (rev 4196)
+++ trunk/EDIMessageFormat.php	2011-01-09 12:53:51 UTC (rev 4197)
@@ -174,13 +174,13 @@
 if (isset($SelectedMessageLine)) {
 	//editing an existing message line
 
-	$sql = 'SELECT messagetype,
+	$sql = "SELECT messagetype,
 			partnercode,
 			section,
 			sequenceno,
 			linetext
 		FROM edimessageformat
-		WHERE id=' . $SelectedMessageLine;
+		WHERE id=" . $SelectedMessageLine;
 
 	$result = DB_query($sql, $db);
 	$myrow = DB_fetch_array($result);
@@ -252,4 +252,4 @@
 echo "</form>";
 
 include('includes/footer.inc');
-?>
\ No newline at end of file
+?>

Modified: trunk/EDIProcessOrders.php
===================================================================
--- trunk/EDIProcessOrders.php	2011-01-09 12:36:52 UTC (rev 4196)
+++ trunk/EDIProcessOrders.php	2011-01-09 12:53:51 UTC (rev 4197)
@@ -40,7 +40,7 @@
 /*Read in the EANCOM Order Segments for the current seg group from the segments table */
 
 
-$sql = 'SELECT id, segtag, maxoccur, seggroup FROM edi_orders_segs';
+$sql = "SELECT id, segtag, maxoccur, seggroup FROM edi_orders_segs";
 $OrderSeg = DB_query($sql,$db);
 $i=0;
 $Seg = array();
@@ -571,4 +571,4 @@
 	}
 }
 
-?>
\ No newline at end of file
+?>

Modified: trunk/EDISendInvoices.php
===================================================================
--- trunk/EDISendInvoices.php	2011-01-09 12:36:52 UTC (rev 4196)
+++ trunk/EDISendInvoices.php	2011-01-09 12:53:51 UTC (rev 4197)
@@ -11,7 +11,7 @@
 include('includes/htmlMimeMail.php'); // need for sending email attachments
 
 /*Get the Customers who are enabled for EDI invoicing */
-$sql = 'SELECT debtorno,
+$sql = "SELECT debtorno,
 		edireference,
 		editransport,
 		ediaddress,
@@ -20,7 +20,7 @@
 		daysbeforedue,
 		dayinfollowingmonth
 	FROM debtorsmaster INNER JOIN paymentterms ON debtorsmaster.paymentterms=paymentterms.termsindicator
-	WHERE ediinvoices=1';
+	WHERE ediinvoices=1";
 
 $EDIInvCusts = DB_query($sql,$db);
 
@@ -261,4 +261,4 @@
 } /*loop around all the customers enabled for EDI Invoices */
 
 include ('includes/footer.inc');
-?>
\ No newline at end of file
+?>

Modified: trunk/ExchangeRateTrend.php
===================================================================
--- trunk/ExchangeRateTrend.php	2011-01-09 12:36:52 UTC (rev 4196)
+++ trunk/ExchangeRateTrend.php	2011-01-09 12:53:51 UTC (rev 4197)
@@ -29,7 +29,7 @@
 		_('View Currency Trend') . '" alt="" />' . ' ' . _('View Currency Trend') . '</p>';
 	echo '<table>'; // First column
 
-	$SQL = 'SELECT * FROM currencies';
+	$SQL = "SELECT * FROM currencies";
 	$result=DB_query($SQL,$db);
 
 
@@ -71,4 +71,4 @@
 
 
 include('includes/footer.inc');
-?>
\ No newline at end of file
+?>


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