Changeset 259 for trunk/npemap.org.uk

Timestamp:

Oct 31, 2006, 6:02:16 PM (14 years ago)

Author:

Nick Burch

Message:

A postcode isn't always unique, so we can't use hash fetch methods, otherwise we'll only see one instance of a postcode

File:

• trunk/npemap.org.uk/cgi/get-postcodes.fcgi (modified) (1 diff)

trunk/npemap.org.uk/cgi/get-postcodes.fcgi

@@ -72 +72 @@
     
     if ($sth->execute($cgi->param('mineasting'), $cgi->param('maxeasting'), $cgi->param('minnorthing'), $cgi->param('maxnorthing'))) {
-        my $hr = $sth->fetchall_hashref('postcode');
         print "Content-type: text/javascript\n\n";
 
-        foreach my $key (keys %$hr) {
-            my $hash = $$hr{$key};
-            print "addMarker('$$hash{postcode}', $$hash{easting}, $$hash{northing}, [$$hash{id}, $$hash{source}]);\n";
+        while(my @row = $sth->fetchrow_array) {
+                        my ($postcode,$easting,$northing,$id,$source) = @row;
+            print "addMarker('$postcode', $easting, $northing, [$id, $source]);\n";
         }
         print "completeMarkers();\n";