Changeset 6506


Ignore:
Timestamp:
06/14/12 18:19:42 (7 years ago)
Author:
eduardow
Message:

Ticket #2858 - SQL inconsistente no Expresso Admin/Gerentes?.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/2.4/expressoAdmin1_2/inc/class.uimanagers.inc.php

    r5593 r6506  
    8888 
    8989                        // Le BD para pegar os administradors. 
    90                         $query = 'SELECT distinct manager_lid manager_lid,context FROM phpgw_expressoadmin_acls ORDER by manager_lid '; 
     90                        $query = 'SELECT DISTINCT ON (manager_lid) manager_lid , context FROM phpgw_expressoadmin_acls ORDER by manager_lid ';  
    9191                        $GLOBALS['phpgw']->db->query($query); 
    9292                        while($GLOBALS['phpgw']->db->next_record()) 
Note: See TracChangeset for help on using the changeset viewer.