Index: /temp/trunk/html/test/kakinaka/mysql.php
===================================================================
--- /temp/trunk/html/test/kakinaka/mysql.php	(revision 4760)
+++ /temp/trunk/html/test/kakinaka/mysql.php	(revision 4761)
@@ -53,5 +53,5 @@
     ) vw_products_allclass ';
 	
-print(preg_replace("/[\r\n\t]/","",$sql));
+print(preg_replace("/[\r\n\t]/"," ",$sql));
 
 print("end");
Index: /temp/trunk/data/class/SC_DbConn.php
===================================================================
--- /temp/trunk/data/class/SC_DbConn.php	(revision 4735)
+++ /temp/trunk/data/class/SC_DbConn.php	(revision 4761)
@@ -52,8 +52,5 @@
 		
 		// mysql¤Î¾ì¹ç¤Ë¤Ï¥Ó¥å¡¼É½¤òÊÑ´¹¤¹¤ë
-		if (DB_TYPE == "mysql") {
-			$n = sfChangeView($n);
-			$n = sfChangeILIKE($n);
-		}
+		if (DB_TYPE == "mysql") $n = sfChangeMySQL($n);
 		
 		if ( $arr ) {
@@ -72,8 +69,5 @@
 
 		// mysql¤Î¾ì¹ç¤Ë¤Ï¥Ó¥å¡¼É½¤òÊÑ´¹¤¹¤ë
-		if (DB_TYPE == "mysql") {
-			$n = sfChangeView($n);
-			$n = sfChangeILIKE($n);
-		}
+		if (DB_TYPE == "mysql") $n = sfChangeMySQL($n);
 
 		if ( $arr ) {
@@ -93,8 +87,5 @@
 
 		// mysql¤Î¾ì¹ç¤Ë¤Ï¥Ó¥å¡¼É½¤òÊÑ´¹¤¹¤ë
-		if (DB_TYPE == "mysql") {
-			$n = sfChangeView($n);
-			$n = sfChangeILIKE($n);
-		}
+		if (DB_TYPE == "mysql") $n = sfChangeMySQL($n);
 		
 		if(PEAR::isError($this->conn)) {
Index: /temp/trunk/data/lib/slib.php
===================================================================
--- /temp/trunk/data/lib/slib.php	(revision 4736)
+++ /temp/trunk/data/lib/slib.php	(revision 4761)
@@ -2340,4 +2340,15 @@
 }
 
+//MySQLÍѤÎSQLʸ¤ËÊѹ¹¤¹¤ë
+function sfChangeMySQL($sql){
+	// ²þ¹Ô¡¢¥¿¥Ö¤ò1¥¹¥Ú¡¼¥¹¤ËÊÑ´¹
+	$sql = preg_replace("/[\r\n\t]/"," ",$sql);
+	
+	$sql = sfChangeView($sql);		// viewɽ¤ò¥¤¥ó¥é¥¤¥ó¥Ó¥å¡¼¤ËÊÑ´¹¤¹¤ë
+	$sql = sfChangeILIKE($sql);	// ILIKE¸¡º÷¤òLIKE¸¡º÷¤ËÊÑ´¹¤¹¤ë
+	
+	return $sql;
+}
+
 // viewɽ¤ò¥¤¥ó¥é¥¤¥ó¥Ó¥å¡¼¤ËÊÑ´¹¤¹¤ë
 function sfChangeView($sql){