From 6a8125da9b09da9fb28ac0eccae1283162d1545d Mon Sep 17 00:00:00 2001 From: Leandro Lucarella Date: Thu, 24 Jul 2003 22:29:30 +0000 Subject: [PATCH] Se pone mas lindo el query de getSistemas (que no deja de ser feo). --- lib/AI/Sistema.php | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/lib/AI/Sistema.php b/lib/AI/Sistema.php index 6c761ae..17a4d02 100644 --- a/lib/AI/Sistema.php +++ b/lib/AI/Sistema.php @@ -190,7 +190,10 @@ FIXME - preguntar a gonzalo si le sirve. $id_field = $conf['id']; $tabla = $conf['base'].'.'.$conf['tabla']; // FIXME - ver como manejar JOINs - Ver de hacer el JOIN tambien en cargar. - $query = "SELECT AI.*, SA.nombre_sistema as nombre, SA.desc_sistema as descripcion FROM $tabla as AI, samurai.sistema as SA WHERE SA.id_sistema = AI.sistema and SA.estado = 1"; + $query = " + SELECT AI.*, SA.nombre_sistema as nombre, SA.desc_sistema as descripcion + FROM $tabla as AI, samurai.sistema as SA + WHERE SA.id_sistema = AI.sistema and SA.estado = 1"; if ($where) { $query .= " WHERE $where"; } -- 2.43.0