Changeset 37

Timestamp:

Oct 15, 2006, 8:56:31 AM (15 years ago)

Author:

Dominic Hargreaves

Message:

Store an empty string in inward rather than NULL (allows concatenation later)

File:

• trunk/npemap.org.uk/cgi/submit.fcgi (modified) (2 diffs)

trunk/npemap.org.uk/cgi/submit.fcgi

@@ -77 +77 @@
         # We are guaranteed to have the first two
         $outward = $first . $second;
-        $inward = $third if $third;
+        $inward = '';
+        $inward .= $third if $third;
         $inward .= $fourth if $fourth;
     } else {
@@ -88 +89 @@
     # corroboration factor; this just catches accidental double-submission
     # really.
-    $sth = $dbh->prepare('SELECT * FROM postcodes WHERE raw_postcode = ? AND easting = ? AND northing = ? AND ip = ?');
+    $sth = $dbh->prepare('SELECT raw_postcode FROM postcodes WHERE raw_postcode = ? AND easting = ? AND northing = ? AND ip = ?');
     unless ($sth->execute($raw_postcode, $easting, $northing, $ENV{'REMOTE_ADDR'})) {
         print_err('Database error when checking for duplicate data :(');