Changeset 4847 for temp/trunk/data

Timestamp:

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

Author:

kakinaka

Message:

blank

Location:

temp/trunk/data

Files:

• class/SC_CustomerList.php (modified) (1 diff)
• lib/slib.php (modified) (2 diffs)

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 ? ";
                     }
                 }

temp/trunk/data/lib/slib.php

@@ -2358 +2358 @@
     
     $sql = sfChangeView($sql);      // viewɽ¤ò¥¤¥ó¥é¥¤¥ó¥Ó¥å¡¼¤ËÊÑ´¹¤¹¤ë
-    $sql = sfChangeILIKE($sql); // ILIKE¸¡º÷¤òLIKE¸¡º÷¤ËÊÑ´¹¤¹¤ë
-    
+    $sql = sfChangeILIKE($sql);     // ILIKE¸¡º÷¤òLIKE¸¡º÷¤ËÊÑ´¹¤¹¤ë
+    $sql = sfChangeLIKE($sql);      // LIKE¸¡º÷¤òLIKE BINARY¸¡º÷¤ËÊÑ´¹¤¹¤ë
+
     return $sql;
 }
@@ -2390 +2391 @@
     return $changesql;
 }
+
+// LIKE¸¡º÷¤òLIKE BINARY¸¡º÷¤ËÊÑ´¹¤¹¤ë
+function sfChangeLIKE($sql){
+    $changesql = eregi_replace("( LIKE )", " LIKE BINARY ", $sql);
+    return $changesql;
+}
+
 
 /* ¥Ç¥Ð¥Ã¥°ÍÑ ------------------------------------------------------------------------------------------------*/