Ignore:
Timestamp:
Oct 24, 2006, 8:06:02 PM (15 years ago)
Author:
Dominic Hargreaves
Message:

Have the deleted flag take effect.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/npemap.org.uk/cgi/bad-postcode.fcgi

    r82 r169  
    4949
    5050    # Check that the requested ID exists
    51     my $sth = $dbh->prepare('SELECT id FROM postcodes WHERE id = ?');
     51    my $sth = $dbh->prepare('SELECT id FROM postcodes WHERE id = ? AND NOT deleted');
    5252    unless ($sth->execute($cgi->param('postcode'))) {
    5353        print_err('Database error when checking for the postcode', $returnlink);
     
    5656
    5757    unless ($sth->rows) {
    58         print_err('A postcode with that identifier does not exist.', $returnlink);
     58        print_err('A postcode with that identifier does not exist, or has already been deleted.', $returnlink);
    5959        next REQUEST;
    6060    }
Note: See TracChangeset for help on using the changeset viewer.