Changeset 16400

Timestamp:

2007/10/13 21:10:06 (17 years ago)

Author:

naka

Message:

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

File:

• branches/feature-module-update/data/class/pages/admin/customer/LC_Page_Admin_Customer_Edit.php (modified) (2 diffs)

branches/feature-module-update/data/class/pages/admin/customer/LC_Page_Admin_Customer_Edit.php

@@ -293 +293 @@
         if (strlen($array["email"]) > 0) {
             $array['email'] = strtolower($array['email']);
-            $sql = "SELECT customer_id FROM dtb_customer WHERE email = ? escape '#' AND (status = 1 OR status = 2) AND del_flg = 0 AND customer_id <> ?";
+            $sql = "SELECT customer_id FROM dtb_customer WHERE email ILIKE ? escape '#' AND (status = 1 OR status = 2) AND del_flg = 0 AND customer_id <> ?";
             $checkMail = ereg_replace( "_", "#_", $array["email"]);
             $result = $this->objConn->getAll($sql, array($checkMail, $array["customer_id"]));
@@ -305 +305 @@
         if (strlen($array["email_mobile"]) > 0) {
             $array['email_mobile'] = strtolower($array['email_mobile']);
-            $sql = "SELECT customer_id FROM dtb_customer WHERE email_mobile = ? escape '#' AND (status = 1 OR status = 2) AND del_flg = 0 AND customer_id <> ?";
+            $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 <> ?";
             $checkMail = ereg_replace( "_", "#_", $array["email_mobile"]);
             $result = $this->objConn->getAll($sql, array($checkMail, $array["customer_id"]));