X-Git-Url: https://git.llucax.com/mecon/ai.git/blobdiff_plain/bf3397e09f20d6ee9ea3bfeec51e56f24118aae9..69a744cc170e8e853ec7946e9b61e7f35f0b2ae7:/lib/AI/Sistema.php

diff --git a/lib/AI/Sistema.php b/lib/AI/Sistema.php
index f0e907d..dc04622 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