Changeset 251 for trunk/web/addons/job_monarch/libtoga.php

Timestamp:

04/13/06 11:40:35 (17 years ago)

Author:

bastiaans

Message:

web/addons/job_monarch/libtoga.php:

• fixed: SQL error that occured when viewing 1 single jobid

File:

• trunk/web/addons/job_monarch/libtoga.php (modified) (2 diffs)

trunk/web/addons/job_monarch/libtoga.php

@@ -144 +144 @@
                 global $SEARCH_RESULT_LIMIT;
 
-                if( $id ) 
-                        $query = "SELECT job_id FROM jobs WHERE job_id = '$id' AND job_status = 'F'";
-                else {
+                if( $id ) {
+                        $select_query = "SELECT job_id FROM jobs WHERE job_id = '$id' AND job_status = 'F'";
+                        $this->resultcount = 1;
+                } else {
                         $query_args = array();
                         
@@ -175 +176 @@
                         }
                         $query .= $extra_query_args;
-                }
-
-                $count_result_idname = "COUNT(job_id)";
-                $select_result_idname = "job_id";
-
-                $count_query = "SELECT " . $count_result_idname . " " . $query;
-
-                $count_result = $this->queryDbase( $count_query );
-                $this->resultcount = (int) $count_result[0][count];
-
-                $select_query = "SELECT " . $select_result_idname . " " . $query . " ORDER BY job_id LIMIT " . $SEARCH_RESULT_LIMIT;
+
+                        $count_result_idname = "COUNT(job_id)";
+                        $select_result_idname = "job_id";
+
+                        $count_query = "SELECT " . $count_result_idname . " " . $query;
+
+                        $count_result = $this->queryDbase( $count_query );
+                        $this->resultcount = (int) $count_result[0][count];
+
+                        $select_query = "SELECT " . $select_result_idname . " " . $query . " ORDER BY job_id LIMIT " . $SEARCH_RESULT_LIMIT;
+                }
+
                 $ids = $this->queryDbase( $select_query );