Changeset 199

Timestamp:

Oct 26, 2006, 11:00:00 PM (14 years ago)

Author:

Nick Burch

Message:

Include ID to, so we can report it as bad

File:

• trunk/npemap.org.uk/cgi/get-distant-postcodes.fcgi (modified) (2 diffs)

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

@@ -72 +72 @@
 
         # Then join to find problem ones
-        my $sql .= "SELECT outward || ' ' || inward AS postcode, $pcpart AS pcpart, easting, northing, avg_easting, avg_northing, id FROM postcodes ";
+        my $sql .= "SELECT id, outward || ' ' || inward AS postcode, $pcpart AS pcpart, easting, northing, avg_easting, avg_northing FROM postcodes ";
         $sql .= "INNER JOIN averages ON ($pcpart = pcpart) ";
         $sql .= "WHERE abs(avg_easting-easting) > $flag_distance ";
@@ -86 +86 @@
         print "Content-type: text/javascript\n\n";
 
-                print "// postcode, match part, easting, northing, avg easting, avg northing\n";
+                print "// id, postcode, match part, easting, northing, avg easting, avg northing\n";
         while(my @row = $sth->fetchrow_array) {
                         # Tidy up avg
-                        my $avg_e = int($row[4]);
-                        my $avg_n = int($row[5]);
+                        my $avg_e = int($row[5]);
+                        my $avg_n = int($row[6]);
 
                         # Print
-                        print "addProblem('$row[0]','$row[1]', $row[2], $row[3], $avg_e, $avg_n);\n";
+                        print "addProblem($row[0],'$row[1]','$row[2]', $row[3], $row[4], $avg_e, $avg_n);\n";
         }
     } else {