Changeset 366 for trunk/npemap.org.uk/cgi/geocoder.fcgi

Timestamp:

Nov 12, 2006, 5:27:42 PM (14 years ago)

Author:

Nick Burch

Message:

Do the area lookup a bit cleaner

File:

• trunk/npemap.org.uk/cgi/geocoder.fcgi (modified) (2 diffs)

trunk/npemap.org.uk/cgi/geocoder.fcgi

@@ -94 +94 @@
 
                 ($easting,$northing,$matched,$pc) = 
-                                execute($area_matcher,$mpart,$mlen,$mlen,$mpart,$mlen);
+                                execute($area_matcher,$mpart,$mlen,$mpart,$mlen);
 
                 unless($matched) {
@@ -159 +159 @@
         my $outer_sql = $base_sql_a . " outward || ' ###'". $base_sql_b . 
                    "AND outward = ? GROUP BY outward";
-        my $area_sql = $base_sql_a . " substr(?,1,?) " . $base_sql_b . 
+        my $area_sql = $base_sql_a . " ? || '' " . $base_sql_b . 
                        "AND substr(outward,1,?) = ? ".
                        "GROUP BY substr(outward,1,?)";