Changeset 222

Timestamp:

2007/02/09 19:31:13 (19 years ago)

Author:

kakinaka

Message:

 

File:

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

branches/dev/data/class/SC_CustomerList.php

@@ -78 +78 @@
         // ̾Á°
         if ( strlen($this->arrSql['name']) > 0 ) {
-            //$this->setWhere("(name01 || name02 LIKE ?)" );
-            $this->setWhere("(name01 LIKE ?)" );
+            if(DB_TYPE == "pgsql"){
+                $this->setWhere("(name01 || name02 LIKE ?)" );
+            }elseif(DB_TYPE == "mysql"){
+                $this->setWhere("concat(name01,name02) LIKE ?)" );
+            }
+
             $searchName = $this->addSearchStr($this->arrSql['name']);
             $this->arrVal[] = mb_ereg_replace("[ ¡¡]+","",$searchName);