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

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

Revision: 4118
          http://weberp.svn.sourceforge.net/weberp/?rev=4118&view=rev
Author:   tim_schofield
Date:     2011-01-08 20:12:19 +0000 (Sat, 08 Jan 2011)

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

Modified Paths:
--------------
    trunk/SalesTypes.php
    trunk/SelectAsset.php

Modified: trunk/SalesTypes.php
===================================================================
--- trunk/SalesTypes.php	2011-01-08 20:12:04 UTC (rev 4117)
+++ trunk/SalesTypes.php	2011-01-08 20:12:19 UTC (rev 4118)
@@ -181,7 +181,7 @@
 links to delete or edit each. These will call the same page again and allow update/input
 or deletion of the records*/
 
-	$sql = 'SELECT * FROM salestypes';
+	$sql = "SELECT * FROM salestypes";
 	$result = DB_query($sql,$db);
 
 	echo '<table class=selection>';

Modified: trunk/SelectAsset.php
===================================================================
--- trunk/SelectAsset.php	2011-01-08 20:12:04 UTC (rev 4117)
+++ trunk/SelectAsset.php	2011-01-08 20:12:19 UTC (rev 4118)
@@ -27,10 +27,10 @@
 	$_POST['AssetCode'] = trim(strtoupper($_POST['AssetCode']));
 }
 // Always show the search facilities
-$SQL = 'SELECT categoryid,
+$SQL = "SELECT categoryid,
 								categorydescription
 							FROM fixedassetcategories
-							ORDER BY categorydescription';
+							ORDER BY categorydescription";
 $result = DB_query($SQL, $db);
 if (DB_num_rows($result) == 0) {
 	echo '<p><font size=4 color=red>' . _('Problem Report') . ':</font><br>' . _('There are no asset categories currently defined please use the link below to set them up');
@@ -79,7 +79,7 @@
 } else {
 	echo '<option value="ALL">' . _('Any asset location') . '</option>';
 }
-$result = DB_query('SELECT locationid, locationdescription FROM fixedassetlocations',$db);
+$result = DB_query("SELECT locationid, locationdescription FROM fixedassetlocations",$db);
 
 while ($myrow = DB_fetch_array($result)) {
 	if ($myrow['locationid'] == $_POST['AssetLocation']) {
@@ -113,12 +113,12 @@
 	if ($_POST['Keywords'] AND $_POST['AssetCode']) {
 		prnMsg( _('Asset description keywords have been used in preference to the asset code extract entered'), 'info' );
 	}
-	$SQL = 'SELECT assetid,
+	$SQL = "SELECT assetid,
 									description,
 									datepurchased,
 									fixedassetlocations.locationdescription
 							FROM fixedassets INNER JOIN fixedassetlocations
-							ON fixedassets.assetlocation=fixedassetlocations.locationid ';
+							ON fixedassets.assetlocation=fixedassetlocations.locationid ";
 
 	if ($_POST['Keywords']) {
 		//insert wildcard characters in spaces


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