Changeset 14107 for branches/dev/data/class

Timestamp:

2007/06/01 15:45:04 (19 years ago)

Author:

nakanishi

Message:

 

File:

• branches/dev/data/class/SC_CustomerList.php (modified) (3 diffs)

branches/dev/data/class/SC_CustomerList.php

@@ -80 +80 @@
         if ( strlen($this->arrSql['name']) > 0 ) {
             if(DB_TYPE == "pgsql"){
-                $this->setWhere("(name01 || name02 LIKE ?)" );
+                $this->setWhere("(name01 || name02) LIKE ?" );
             }elseif(DB_TYPE == "mysql"){
                 $this->setWhere("concat(name01,name02) LIKE ?" );
@@ -92 +92 @@
         if ( strlen($this->arrSql['kana']) > 0 ) {
             if(DB_TYPE == "pgsql"){
-                $this->setWhere("(kana01 || kana02 LIKE ?)");
+                $this->setWhere("(kana01 || kana02) LIKE ?");
             }elseif(DB_TYPE == "mysql"){
                 $this->setWhere("concat(kana01,kana02) LIKE ?" );
@@ -216 +216 @@
                     } elseif($this->arrSql['domain'] == 3) {
                         if($sql_where == "") {
-                            $sql_where .= "dtb_customer.email LIKE ? ";
+                            $sql_where .= "dtb_customer.email ILIKE ? ";
                         } else {
-                            $sql_where .= "OR dtb_customer.email LIKE ? " ;
+                            $sql_where .= "OR dtb_customer.email ILIKE ? " ;
                         }
                     }