Changeset 12493

Timestamp:

2007/05/10 18:42:55 (17 years ago)

Author:

matsumoto

Message:

 

File:

• branches/dev/data/class/SC_CustomerList.php (modified) (1 diff)

branches/dev/data/class/SC_CustomerList.php

@@ -214 +214 @@
                 if($domain==3){
                     if($this->arrSql['mail_type']==1){
-                        $sql_where .= "OR dtb_customer.email LIKE ? " ;
+                        if($sql_where == "") {
+                            $sql_where = "dtb_customer.email ILIKE ? ";
+                        } else {
+                            $sql_where .= "OR dtb_customer.email LIKE ? " ;
+                        }
                 }elseif($this->arrSql['mail_type']==2){
                         $sql_where .= "OR dtb_customer.email_mobile LIKE ? " ;