Changeset 468 for branches/htmlform/cgi-bin/search.cgi

Timestamp:

08/12/10 12:00:28 (14 years ago)

Author:

Kris Deugau

Message:

/branches/htmlform

Merge trunk bugfixes and updates

Location:

branches/htmlform

Files:

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

branches/htmlform/cgi-bin/search.cgi

@@ -139 +139 @@
   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}%')";
@@ -353 +352 @@
     # 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";