Changeset 14109
- Timestamp:
- 2007/06/01 15:58:20 (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/dev/data/class/SC_CustomerList.php
r14107 r14109 80 80 if ( strlen($this->arrSql['name']) > 0 ) { 81 81 if(DB_TYPE == "pgsql"){ 82 $this->setWhere("(name01 || name02 ) LIKE ?" );82 $this->setWhere("(name01 || name02 LIKE ?)" ); 83 83 }elseif(DB_TYPE == "mysql"){ 84 84 $this->setWhere("concat(name01,name02) LIKE ?" ); … … 92 92 if ( strlen($this->arrSql['kana']) > 0 ) { 93 93 if(DB_TYPE == "pgsql"){ 94 $this->setWhere("(kana01 || kana02 ) LIKE ?");94 $this->setWhere("(kana01 || kana02 LIKE ?)"); 95 95 }elseif(DB_TYPE == "mysql"){ 96 96 $this->setWhere("concat(kana01,kana02) LIKE ?" ); … … 218 218 $sql_where .= "dtb_customer.email ILIKE ? "; 219 219 } else { 220 $sql_where .= "OR dtb_customer.email ILIKE ? " ;220 $sql_where .= "OR dtb_customer.email LIKE ? " ; 221 221 } 222 $sql_where = "(".$sql_where.")"; 222 223 } 223 224 $searchDomain = $this->addSearchStr($val);
Note: See TracChangeset
for help on using the changeset viewer.