[Phpgroupware-cvs] property/inc/export GABNr,1.4

[sigurdne]

Update of property/inc/export

Modified Files:
     Branch: MAIN
            GABNr lines: +1 -1

Log Message:
no message

====================================================
Index: property/inc/export/GABNr
diff -u property/inc/export/GABNr:1.3 property/inc/export/GABNr:1.4
--- property/inc/export/GABNr:1.3       Tue Oct 12 13:51:41 2004
+++ property/inc/export/GABNr   Mon Feb  7 14:58:56 2005
@@ -84,7 +84,7 @@

                        //Velg ut alle GABNr som skal overføres

-                       $sql = "SELECT gab_id,loc1 FROM fm_gab_location WHERE 
owner = 'yes' GROUP BY gab_id,loc1 order by gab_id asc";
+                       $sql = "SELECT gab_id,fm_gab_location.loc1 FROM 
fm_gab_location $this->join fm_location1 on fm_gab_location.loc1 = 
fm_location1.loc1 WHERE owner = 'yes' AND ((fm_location1.category <> 99) OR 
(fm_location1.category IS NULL)) GROUP BY gab_id,fm_gab_location.loc1 order by 
gab_id asc";

                        $this->db->query($sql,__LINE__,__FILE__);