Changeset 16380 for branches/feature-module-update/data/class/SC_Customer.php

Timestamp:

2007/10/11 16:57:39 (19 years ago)

Author:

nanasess

Message:

email の ILIKE 検索を修正

File:

• branches/feature-module-update/data/class/SC_Customer.php (modified) (1 diff)

branches/feature-module-update/data/class/SC_Customer.php

@@ -171 +171 @@
     function setLogin($email) {
         // 本登録された会員のみ
-        $sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND del_flg = 0 AND status = 2";
+        $sql = "SELECT * FROM dtb_customer WHERE email = ? AND del_flg = 0 AND status = 2";
         $result = $this->conn->getAll($sql, array($email));
         $data = isset($result[0]) ? $result[0] : "";