Changeset 696 for trunk

Timestamp:

Sep 5, 2009, 2:54:20 PM (10 years ago)

Author:

Dominic Hargreaves

Message:

null reason

File:

• trunk/npemap.org.uk/scripts/report-foreign-deletions (modified) (1 diff)

trunk/npemap.org.uk/scripts/report-foreign-deletions

@@ -36 +36 @@
 
 my $sql = <<EOF;
-SELECT id,outward||' '||inward AS postcode,coalesce(to_char(easting,'000000'),''),coalesce(to_char(northing,'000000'),''),coalesce(to_char(ie_easting,'000000'),''),coalesce(to_char(ie_northing,'000000'),''),reason from postcodes p inner join bad_postcodes b on (p.id=b.postcode) where source=? and delete_reason=1 and deleted='t' order by id;
+SELECT id,outward||' '||inward AS postcode,coalesce(to_char(easting,'000000'),''),coalesce(to_char(northing,'000000'),''),coalesce(to_char(ie_easting,'000000'),''),coalesce(to_char(ie_northing,'000000'),''),coalesce(reason,'') from postcodes p inner join bad_postcodes b on (p.id=b.postcode) where source=? and delete_reason=1 and deleted='t' order by id;
 EOF