Changeset 6367 for temp/trunk

Timestamp:

2006/10/16 12:42:43 (20 years ago)

Author:

kakinaka

Message:

* empty log message *

File:

• temp/trunk/html/admin/contents/csv_sql.php (modified) (5 diffs)

temp/trunk/html/admin/contents/csv_sql.php

@@ -260 +260 @@
 function lfCheckError($data){
     $objErr = new SC_CheckError();
-    $objErr->doFunc( array("̾¾Î", "name"), array("EXIST_CHECK") );
-    $objErr->doFunc( array("SQLʸ", "sql", "30000"), array("EXIST_CHECK", "MAX_LENGTH_CHECK") );
+    $objErr->doFunc( array("̾¾Î", "sql_name"), array("EXIST_CHECK") );
+    $objErr->doFunc( array("SQLʸ", "csv_sql", "30000"), array("EXIST_CHECK", "MAX_LENGTH_CHECK") );
     
     // SQL¤ÎÂÅÅöÀ­¥Á¥§¥Ã¥¯
@@ -267 +267 @@
         $objsqlErr = lfCheckSQL($data);
         if ($objsqlErr != "") {
-            $objErr->arrErr["sql"] = "SQLʸ¤¬ÉÔÀµ¤Ç¤¹¡£SQLʸ¤ò¸«Ä¾¤·¤Æ¤¯¤À¤µ¤¤";
+            $objErr->arrErr["csv_sql"] = "SQLʸ¤¬ÉÔÀµ¤Ç¤¹¡£SQLʸ¤ò¸«Ä¾¤·¤Æ¤¯¤À¤µ¤¤";
         }
     }
@@ -284 +284 @@
     $err = "";
     $objDbConn = new SC_DbConn();
-    $sql = "SELECT " . $data['sql'] . " ";
+    $sql = "SELECT " . $data['csv_sql'] . " ";
     $ret = $objDbConn->conn->query($sql);
     if ($objDbConn->conn->isError($ret)){
@@ -317 +317 @@
             // ¥Ç¡¼¥¿¹¹¿·
             $sql = "UPDATE dtb_csv_sql SET sql_name = ?, csv_sql = ?, update_date = now() WHERE sql_id = ? ";
-            $arrVal= array($arrData['name'], $arrData['sql'], $sql_id);
+            $arrVal= array($arrData['sql_name'], $arrData['csv_sql'], $sql_id);
         }else{
             // ¥Ç¡¼¥¿¤Î¿·µ¬ºîÀ®
             $sql_id = "";
             $sql = "INSERT INTO dtb_csv_sql (sql_name, csv_sql, create_date, update_date) values (?, ?, now(), now()) ";
-            $arrVal= array($arrData['name'], $arrData['sql']);
+            $arrVal= array($arrData['sql_name'], $arrData['csv_sql']);
             
         }
@@ -328 +328 @@
         // ¥Ç¡¼¥¿¤Î¿·µ¬ºîÀ®
         $sql = "INSERT INTO dtb_csv_sql (sql_name, csv_sql, create_date, update_date) values (?, ?, now(), now()) ";
-        $arrVal= array($arrData['name'], $arrData['sql']);
+        $arrVal= array($arrData['sql_name'], $arrData['csv_sql']);
     }
     // SQL¼Â¹Ô