[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Fmsystem-commits] [8004]
From: |
Erik Holm-Larsen |
Subject: |
[Fmsystem-commits] [8004] |
Date: |
Thu, 03 Nov 2011 09:12:52 +0000 |
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()) {
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Fmsystem-commits] [8004],
Erik Holm-Larsen <=