Changeset 389

Timestamp:

02/18/10 15:03:12 (16 years ago)

Author:

Kris Deugau

Message:

/branches/stable

Commit lurking fix/extension to search descriptions for CustIDs

File:

• branches/stable/cgi-bin/search.cgi (modified) (1 diff)

branches/stable/cgi-bin/search.cgi

@@ -295 +295 @@
     # 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%'";
+    $sql = "select $cols from searchme where custid ilike '%$query%' or oldcustid ilike '%$query%' or description like '%$query%'";
     my $count = countRows($sql);
     $sql .= " order by cidr limit $RESULTS_PER_PAGE offset $offset";