Changeset 366 for trunk/npemap.org.uk


Ignore:
Timestamp:
Nov 12, 2006, 5:27:42 PM (14 years ago)
Author:
Nick Burch
Message:

Do the area lookup a bit cleaner

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/npemap.org.uk/cgi/geocoder.fcgi

    r365 r366  
    9494
    9595                ($easting,$northing,$matched,$pc) =
    96                                 execute($area_matcher,$mpart,$mlen,$mlen,$mpart,$mlen);
     96                                execute($area_matcher,$mpart,$mlen,$mpart,$mlen);
    9797
    9898                unless($matched) {
     
    159159        my $outer_sql = $base_sql_a . " outward || ' ###'". $base_sql_b .
    160160                   "AND outward = ? GROUP BY outward";
    161         my $area_sql = $base_sql_a . " substr(?,1,?) " . $base_sql_b .
     161        my $area_sql = $base_sql_a . " ? || '' " . $base_sql_b .
    162162                       "AND substr(outward,1,?) = ? ".
    163163                       "GROUP BY substr(outward,1,?)";
Note: See TracChangeset for help on using the changeset viewer.