X-Git-Url: https://git.llucax.com/mecon/ai.git/blobdiff_plain/bf3397e09f20d6ee9ea3bfeec51e56f24118aae9..89f9ee9162349d9d5027d60f6db398a8c2767f17:/lib/AI/Sistema.php?ds=inline

diff --git a/lib/AI/Sistema.php b/lib/AI/Sistema.php
index f0e907d..a2a2045 100644
--- a/lib/AI/Sistema.php
+++ b/lib/AI/Sistema.php
@@ -200,7 +200,7 @@ class AI_Sistema extends AI_DBObject {
         extract($conf);
         // FIXME - ver como manejar JOINs - Ver de hacer el JOIN tambien en cargar.
         $query = "
-            SELECT    SA.nombre_sistema, SA.id_sistema
+            SELECT    SA.id_sistema, SA.nombre_sistema
             FROM      samurai.sistema as SA
             LEFT JOIN $base.$tabla as AI
             ON        AI.sistema = SA.id_sistema
@@ -209,7 +209,7 @@ class AI_Sistema extends AI_DBObject {
             $query .= " AND $where";
         }
         $query .= " ORDER BY SA.nombre_sistema ASC";
-        return $db->getCol($query);
+        return $db->getAssoc($query);
     }
     // -X2C
 
@@ -267,4 +267,4 @@ class AI_Sistema extends AI_DBObject {
 
 } // -X2C Class :AI_Sistema
 
-?>
+?>
\ No newline at end of file