[freeipdb-hackers] MOD: case insensitive text searching for $custdesc

[Josh Richards]

The following very simple patch makes searches using the Customer Name
($custdesc) field case insensitive which works better for us here.
YMMV.  This patch is based on today's CVS of 0.1.5.

--cut here--

*** dist/ipdb_httpcgi.pl        Thu May 30 14:49:39 2002
--- ipdb_httpcgi.pl     Thu May 30 14:59:30 2002
***************
*** 200,206 ****
        if($id){
                $query = $query." AND ID = $id";
        } else {
!               if($custdesc){$query = $query." AND CUSTDESC LIKE '%$custdesc%'";}
                if($cust){$query = $query." AND CUSTNUM LIKE '%$cust%'";}
                if($region !~ m/---/){$query = $query." AND REGION = $region";}
                if($bits =~ m/^[0-9]+$/){$query = $query." AND BITS = $bits";}
--- 200,206 ----
        if($id){
                $query = $query." AND ID = $id";
        } else {
!               if($custdesc){$query = $query." AND CUSTDESC ILIKE '%$custdesc%'";}
                if($cust){$query = $query." AND CUSTNUM LIKE '%$cust%'";}
                if($region !~ m/---/){$query = $query." AND REGION = $region";}
                if($bits =~ m/^[0-9]+$/){$query = $query." AND BITS = $bits";}


--cut here--

-jr

-- 
Josh Richards <jrichard@{ digitalwest.net, geekresearch.com, cubicle.net }>
Digital West Networks, Inc. - "Making Internet Business Better"
San Luis Obispo, CA - <URL:http://www.digitalwest.net/> - ASN 14589