Changeset 16400


Ignore:
Timestamp:
2007/10/13 21:10:06 (15 years ago)
Author:
naka
Message:

escape句が=で使用されているとエラーが出るので修正

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/feature-module-update/data/class/pages/admin/customer/LC_Page_Admin_Customer_Edit.php

    r16380 r16400  
    293293        if (strlen($array["email"]) > 0) { 
    294294            $array['email'] = strtolower($array['email']); 
    295             $sql = "SELECT customer_id FROM dtb_customer WHERE email = ? escape '#' AND (status = 1 OR status = 2) AND del_flg = 0 AND customer_id <> ?"; 
     295            $sql = "SELECT customer_id FROM dtb_customer WHERE email ILIKE ? escape '#' AND (status = 1 OR status = 2) AND del_flg = 0 AND customer_id <> ?"; 
    296296            $checkMail = ereg_replace( "_", "#_", $array["email"]); 
    297297            $result = $this->objConn->getAll($sql, array($checkMail, $array["customer_id"])); 
     
    305305        if (strlen($array["email_mobile"]) > 0) { 
    306306            $array['email_mobile'] = strtolower($array['email_mobile']); 
    307             $sql = "SELECT customer_id FROM dtb_customer WHERE email_mobile = ? escape '#' AND (status = 1 OR status = 2) AND del_flg = 0 AND customer_id <> ?"; 
     307            $sql = "SELECT customer_id FROM dtb_customer WHERE email_mobile ILIKE ? escape '#' AND (status = 1 OR status = 2) AND del_flg = 0 AND customer_id <> ?"; 
    308308            $checkMail = ereg_replace( "_", "#_", $array["email_mobile"]); 
    309309            $result = $this->objConn->getAll($sql, array($checkMail, $array["customer_id"])); 
Note: See TracChangeset for help on using the changeset viewer.