Changeset 391

Timestamp:

Nov 22, 2006, 9:42:19 AM (15 years ago)

Author:

David Sheldon

Message:

Fix problem with CH3 4 and CH34 the same.

File:

• trunk/npemap.org.uk/scripts/exporter/updatePostcodeine.pl (modified) (2 diffs)

trunk/npemap.org.uk/scripts/exporter/updatePostcodeine.pl

@@ -44 +44 @@
 # Process the query
 $query->execute;
-while(my ($outer,$inner,$e,$n) = $query->fetchrow_array) {
+while(my ($outer,$e,$n) = $query->fetchrow_array) {
     $e =~ s/^(\d+)\.\d+$/$1/;
     $n =~ s/^(\d+)\.\d+$/$1/;
-    my $pcode = "$outer$inner";
+    my $pcode = $outer;
     if (length($pcode) > 2) {
             print OUT "\"$pcode\",$e,$n\n";
@@ -65 +65 @@
 
 # Get a query returning 
-#               outer, inner, easting, northing
+#               outer . inner, easting, northing
 sub getQuery {
         my ($conn) = @_;
 
     my $sql = 
-        "SELECT outward, inward, AVG(easting) AS avg_easting, AVG(northing) AS avg_northing ".
+        "SELECT outward || inward, AVG(easting) AS avg_easting, AVG(northing) AS avg_northing ".
         "FROM postcodes  ".
         "WHERE NOT deleted ".
-        "GROUP BY outward, inward ".
+        "GROUP BY outward || inward ".
         "ORDER BY outward || inward ";