Changeset 277 for trunk/npemap.org.uk

Timestamp:

Nov 1, 2006, 10:01:25 PM (14 years ago)

Author:

David Sheldon

Message:

Order better.

File:

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

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

@@ -1 +1 @@
 #!/usr/bin/perl
+
 
 #                                       Postcode Data Exporter
@@ -71 +72 @@
         "WHERE NOT deleted ".
         "GROUP BY outward, inward ".
-        "ORDER BY outward, inward ";
+        "ORDER BY outward || inward ";
 
     my $sth = $conn->prepare($sql);