Changeset 49 for branches/stable


Ignore:
Timestamp:
11/02/04 12:36:47 (20 years ago)
Author:
Kris Deugau
Message:

/branches/stable

Bugfix to allow case-insensitive searches

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/stable/cgi-bin/main.cgi

    r48 r49  
    253253    # Query for a customer ID.  Note that we can't restrict to "numeric-only"
    254254    # as we have non-numeric custIDs in the legacy data.  :/
    255     $sql = "select * from searchme where custid like '%$query%'";
     255    $sql = "select * from searchme where custid ilike '%$query%'";
    256256    my $count = countRows("select count(*) from ($sql) foo");
    257257    $sql .= " order by cidr limit $RESULTS_PER_PAGE offset $offset";
     
    262262    print qq(<div class="heading">Searching for descriptions containing '$query'</div><br>\n);
    263263    # Query based on description (includes "name" from old DB).
    264     $sql = "select * from searchme where description like '%$query%'";
     264    $sql = "select * from searchme where description ilike '%$query%'";
    265265    my $count = countRows("select count(*) from ($sql) foo");
    266266    $sql .= " order by cidr limit $RESULTS_PER_PAGE offset $offset";
Note: See TracChangeset for help on using the changeset viewer.