Changeset 17202


Ignore:
Timestamp:
2008/04/04 10:40:39 (12 years ago)
Author:
satou
Message:

#258 MySQLの場合にILIKE検索できない不具合を改修。

Location:
branches/version-2/data/class
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2/data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php

    r16938 r17202  
    217217     */ 
    218218    function sfChangeILIKE($sql){ 
    219         $changesql = eregi_replace("(ILIKE )", "LIKE BINARY ", $sql); 
     219        $changesql = eregi_replace("(ILIKE )", "LIKE ", $sql); 
    220220        return $changesql; 
    221221    } 
  • branches/version-2/data/class/pages/admin/products/LC_Page_Admin_Products.php

    r17192 r17202  
    180180                            break; 
    181181                        case 'search_name':         // 商品名 
    182                             $where .= " AND name LIKE ?"; 
    183                             $view_where .= " AND name LIKE ?"; 
     182                            $where .= " AND name ILIKE ?"; 
     183                            $view_where .= " AND name ILIKE ?"; 
    184184                            $arrval[] = "%$val%"; 
    185185                            break; 
  • branches/version-2/data/class/pages/admin/products/LC_Page_Admin_Products_ProductSelect.php

    r16824 r17202  
    8585                switch ($key) { 
    8686                case 'search_name': 
    87                     $where .= " AND name LIKE ?"; 
     87                    $where .= " AND name ILIKE ?"; 
    8888                    $arrval[] = "%$val%"; 
    8989                    break; 
Note: See TracChangeset for help on using the changeset viewer.