[Fmsystem-commits] [8004]

[Erik Holm-Larsen]

Revision: 8004
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=8004
Author:   erikhl
Date:     2011-11-03 09:12:52 +0000 (Thu, 03 Nov 2011)
Log Message:
-----------


Modified Paths:
--------------
    trunk/controller/inc/class.soprocedure.inc.php

Modified: trunk/controller/inc/class.soprocedure.inc.php
===================================================================
--- trunk/controller/inc/class.soprocedure.inc.php      2011-11-03 09:07:07 UTC 
(rev 8003)
+++ trunk/controller/inc/class.soprocedure.inc.php      2011-11-03 09:12:52 UTC 
(rev 8004)
@@ -143,7 +143,9 @@
                $order = $sort ? "ORDER BY $sort $dir ": '';
                
                //$sql = "SELECT * FROM controller_procedure WHERE $condition 
$order";
-               $sql = "SELECT * FROM controller_procedure $order";
+               
+               $condition = "WHERE end_date IS NULL";
+               $sql = "SELECT * FROM controller_procedure $condition $order";
                $this->db->limit_query($sql, $start, __LINE__, __FILE__, 
$limit);
                
                while ($this->db->next_record()) {
@@ -174,7 +176,9 @@
                $order = $sort ? "ORDER BY $sort $dir ": '';
                
                //$sql = "SELECT * FROM controller_procedure WHERE $condition 
$order";
-               $sql = "SELECT * FROM controller_procedure $order";
+               
+               $condition = "WHERE end_date IS NULL";
+               $sql = "SELECT * FROM controller_procedure $condition $order";
                $this->db->limit_query($sql, $start, __LINE__, __FILE__, 
$limit);
                
                while ($this->db->next_record()) {