From dbdf767030f1adc10e0559ac6dd3fef2b4a5ed29 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Fri, 7 Feb 2014 21:31:26 +0100 Subject: [PATCH] fix syntax of route linestring --- lib/Geocode.php | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/lib/Geocode.php b/lib/Geocode.php index e3fa25b6..132be9a5 100644 --- a/lib/Geocode.php +++ b/lib/Geocode.php @@ -417,11 +417,12 @@ if ($this->aRoutePoints) { $sViewboxCentreSQL = "ST_SetSRID('LINESTRING("; - $bFirst = false; - foreach($this->aRouteaPoints as $aPoint) + $bFirst = true; + foreach($this->aRoutePoints as $aPoint) { if (!$bFirst) $sViewboxCentreSQL .= ","; $sViewboxCentreSQL .= $aPoint[1].' '.$aPoint[0]; + $bFirst = false; } $sViewboxCentreSQL .= ")'::geometry,4326)"; -- 2.39.5