Changeset 5302 for temp/trunk/html/admin/contents/csv_sql.php

Timestamp:

2006/09/21 17:16:26 (20 years ago)

Author:

kakinaka

Message:

blank

File:

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

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

@@ -330 +330 @@
         if (count($arrSqlData) > 0) {
             // ¥Ç¡¼¥¿¹¹¿·
-            $sql = "UPDATE dtb_csv_sql SET name = ?, sql = ?, update_date = now() WHERE sql_id = ? ";
+            $sql = "UPDATE dtb_csv_sql SET sql_name = ?, csv_sql = ?, update_date = now() WHERE sql_id = ? ";
             $arrVal= array($arrData['name'], $arrData['sql'], $sql_id);
         }else{
             // ¥Ç¡¼¥¿¤Î¿·µ¬ºîÀ®
             $sql_id = "";
-            $sql = "INSERT INTO dtb_csv_sql (name, sql, create_date, update_date) values (?, ?, now(), now()) ";
+            $sql = "INSERT INTO dtb_csv_sql (sql_name, csv_sql, create_date, update_date) values (?, ?, now(), now()) ";
             $arrVal= array($arrData['name'], $arrData['sql']);
             
@@ -341 +341 @@
     }else{
         // ¥Ç¡¼¥¿¤Î¿·µ¬ºîÀ®
-        $sql = "INSERT INTO dtb_csv_sql (name, sql, create_date, update_date) values (?, ?, now(), now()) ";
+        $sql = "INSERT INTO dtb_csv_sql (sql_name, csv_sql, create_date, update_date) values (?, ?, now(), now()) ";
         $arrVal= array($arrData['name'], $arrData['sql']);
     }