[phpBT-dev] CVS: phpbt report.php,1.20,1.21 index.php,1.23,1.24

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv18193

Modified Files:
	report.php index.php 
Log Message:
Some Oracle tweaks suggested by Liam

Index: report.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/report.php,v
retrieving revision 1.20
retrieving revision 1.21
diff -u -r1.20 -r1.21
--- report.php	17 Mar 2002 01:42:40 -0000	1.20
+++ report.php	27 Mar 2002 18:01:33 -0000	1.21
@@ -69,6 +69,7 @@
 		$t->parse('rows', 'row', true);
 		$t->set_var('cols', '');
 		$i = 0;
+		$db->setOption('optimize', 'performance'); // For Oracle to do this loop
 		while ($rs->fetchInto($row)) {
 			foreach ($resfields as $col) {
 				if (!isset($row[$col]) || $row[$col] == '') {
@@ -91,6 +92,7 @@
 			//for header default
 			$t->set_var('trclass','alt');
 		}
+		$db->setOption('optimize', 'portability'); 
 	}
 }
 

Index: index.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/index.php,v
retrieving revision 1.23
retrieving revision 1.24
diff -u -r1.23 -r1.24
--- index.php	26 Mar 2002 18:44:32 -0000	1.23
+++ index.php	27 Mar 2002 18:01:33 -0000	1.24
@@ -155,6 +155,7 @@
 		$t->parse('prows', 'projectrow', true);
 		$t->set_var('cols', '');
 		$i = 0;
+		$db->setOption('optimize', 'performance'); // For Oracle to do this loop
 		while ($rs->fetchInto($row)) {
 			foreach ($resfields as $col) {
 				$t->set_var(array(
@@ -172,6 +173,7 @@
 		}
 		$t->parse('projblock', 'projectsummaryblock', true);
 		$rs->free();
+		$db->setOption('optimize', 'portability'); 
 	}
 } else {
 	$t->set_var('projblock', '');