Changeset 325
- Timestamp:
- Nov 5, 2006, 12:42:23 PM (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/npemap.org.uk/scripts/process-problems
r320 r325 10 10 use NPEMap; 11 11 12 # Optionally, limit by the postcode ID 13 my $postcode_id = shift; 14 my $postcode_where = ""; 15 if($postcode_id && $postcode_id =~ /^\d+$/) { 16 $postcode_where = " AND p.id = $postcode_id "; 17 } 18 19 # Get the postcodes 12 20 my $dbh = setup_dbh() or die $!; 13 21 … … 17 25 p.easting, p.northing 18 26 FROM bad_postcodes AS b INNER JOIN postcodes AS p ON (b.postcode = p.id) 19 WHERE not b.actioned 27 WHERE not b.actioned $postcode_where 20 28 ORDER BY p.id, b.created_at 21 29 EOF
Note: See TracChangeset
for help on using the changeset viewer.