[Weberp-svn] SF.net SVN: weberp:[8185] trunk/WorkOrderEntry.php

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

Revision: 8185
          http://weberp.svn.sourceforge.net/weberp/?rev=8185&view=rev
Author:   tim_schofield
Date:     2011-09-25 20:30:30 +0000 (Sun, 25 Sep 2011)
Log Message:
-----------
Remove all SELECT * references, only choose those fields that are needed

Modified Paths:
--------------
    trunk/WorkOrderEntry.php

Modified: trunk/WorkOrderEntry.php
===================================================================
--- trunk/WorkOrderEntry.php	2011-09-25 20:30:20 UTC (rev 8184)
+++ trunk/WorkOrderEntry.php	2011-09-25 20:30:30 UTC (rev 8185)
@@ -355,7 +355,7 @@
 	$CancelDelete=false; //always assume the best
 
 	// can't delete it there are open work issues
-	$HasTransResult = DB_query("SELECT * FROM stockmoves
+	$HasTransResult = DB_query("SELECT transno FROM stockmoves
 									WHERE (stockmoves.type= 26 OR stockmoves.type=28)
 									AND reference " . LIKE  . " '%" . $_POST['WO'] . "%'",$db);
 	if (DB_num_rows($HasTransResult)>0){
@@ -450,7 +450,7 @@
 				}
 		  		$_POST['Controlled'.$i] =$WOItem['controlled'];
 		  		$_POST['Serialised'.$i] =$WOItem['serialised'];
-		  		$HasWOSerialNosResult = DB_query("SELECT * FROM woserialnos WHERE wo='" . $_POST['WO'] . "'",$db);
+		  		$HasWOSerialNosResult = DB_query("SELECT wo FROM woserialnos WHERE wo='" . $_POST['WO'] . "'",$db);
 		  		if (DB_num_rows($HasWOSerialNosResult)>0){
 		  		   $_POST['HasWOSerialNos']=true;
 		  		} else {

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