Changeset 61

Timestamp:

Oct 16, 2006, 2:37:35 PM (14 years ago)

Author:

David Sheldon

Message:

Use BETWEEN rather than >= and <= in SELECT

File:

• trunk/npemap.org.uk/cgi/get-postcodes.fcgi (modified) (1 diff)

trunk/npemap.org.uk/cgi/get-postcodes.fcgi

@@ -70 +70 @@
     }
 
-    my $sth = $dbh->prepare("SELECT outward || ' ' || inward AS postcode, easting, northing FROM postcodes WHERE easting >= ? AND easting <= ? AND northing >= ? AND northing <= ?");
+    my $sth = $dbh->prepare("SELECT outward || ' ' || inward AS postcode, easting, northing FROM postcodes WHERE easting BETWEEN ? AND ? AND northing BETWEEN ? AND ?");
     if ($sth->execute($cgi->param('mineasting'), $cgi->param('maxeasting'), $cgi->param('minnorthing'), $cgi->param('maxnorthing'))) {
         my $hr = $sth->fetchall_hashref('postcode');