Changeset 4847 for temp/trunk/data/class/SC_CustomerList.php

Timestamp:

2006/09/17 13:57:36 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/data/class/SC_CustomerList.php (modified) (1 diff)

temp/trunk/data/class/SC_CustomerList.php

@@ -130 +130 @@
                 if($this->arrSql['not_emailinc'] == '1') {
                     if($sql_where == "") {
-                        $sql_where .= "email NOT ILIKE ? ";
+                        $sql_where .= "dtb_customer.email NOT ILIKE ? ";
                     } else {
-                        $sql_where .= "AND email NOT ILIKE ? ";
+                        $sql_where .= "AND dtb_customer.email NOT ILIKE ? ";
                     }
                 } else {                
                     if($sql_where == "") {
-                        $sql_where .= "email ILIKE ? ";
+                        $sql_where .= "dtb_customer.email ILIKE ? ";
                     } else {
-                        $sql_where .= "OR email ILIKE ? ";
+                        $sql_where .= "OR dtb_customer.email ILIKE ? ";
                     }
                 }