[Fmsystem-commits] [9825] property : fix sql

[Sigurd Nes]

Revision: 9825
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=9825
Author:   sigurdne
Date:     2012-08-02 12:42:04 +0000 (Thu, 02 Aug 2012)
Log Message:
-----------
property : fix sql

Modified Paths:
--------------
    trunk/property/inc/class.solocation.inc.php

Modified: trunk/property/inc/class.solocation.inc.php
===================================================================
--- trunk/property/inc/class.solocation.inc.php 2012-08-02 12:23:23 UTC (rev 
9824)
+++ trunk/property/inc/class.solocation.inc.php 2012-08-02 12:42:04 UTC (rev 
9825)
@@ -1520,7 +1520,7 @@
                        $locations = array();
                        for ($i=1;$i<($levels+1);$i++)
                        {
-                               $this->db->query("SELECT 
fm_location{$i}.location_code, loc1 FROM fm_location{$i} {$this->left_join} 
fm_locations ON fm_location{$i}.location_code = fm_locations.location_code 
WHERE fm_locations.location_code IS NULL");
+                               $this->db->query("SELECT 
fm_location{$i}.location_code, fm_location{$i}.loc1 FROM fm_location{$i} 
{$this->left_join} fm_locations ON fm_location{$i}.location_code = 
fm_locations.location_code WHERE fm_locations.location_code IS NULL");
                                while($this->db->next_record())
                                {
                                        $locations[] = array