Changeset 455 for trunk/cgi-bin/search.cgi

Timestamp:

07/30/10 15:40:36 (14 years ago)

Author:

Kris Deugau

Message:

/trunk

Remove reference to legacy oldcustid field - leftovers from a
billing system transition. See #26.

File:

• trunk/cgi-bin/search.cgi (modified) (2 diffs)

trunk/cgi-bin/search.cgi

@@ -128 +128 @@
   my $sql = "(select $cols from searchme where".
         " $webvar{custexclude} (custid ilike '%$webvar{custid}%'".
-        " OR $webvar{custexclude} oldcustid ilike '%$webvar{custid}%'))".
         " $sqlconcat (select $cols from searchme where $webvar{descexclude} description ilike '%$webvar{desc}%')".
         " $sqlconcat (select $cols from searchme where $webvar{notesexclude} notes ilike '%$webvar{notes}%')";
@@ -335 +334 @@
     # Query for a customer ID.  Note that we can't restrict to "numeric-only"
     # as we have non-numeric custIDs in the legacy data.  :/
-    $sql = "select $cols from searchme where custid ilike '%$query%' or oldcustid ilike '%$query%' or description like '%$query%'";
+    $sql = "select $cols from searchme where custid ilike '%$query%' or description like '%$query%'";
     my $count = countRows($sql);
     $sql .= " order by cidr limit $RESULTS_PER_PAGE offset $offset";