Changeset 5127

Timestamp:

2006/09/19 13:17:59 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk/html/admin/contents

Files:

• csv_sql.php (modified) (2 diffs)
• inquiry.php (modified) (1 diff)

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

@@ -218 +218 @@
     $objQuery = new SC_Query();
     $arrRet = array();      // ·ë²Ì¼èÆÀÍÑ
-    /*
-    $sql = "";
-    $sql .= " SELECT";
-    $sql .= "     a.attname,";
-    $sql .= "     a.attnum as fldnum, ";
-    $sql .= "     (select case count(description) when 0 then a.attname else (select a.attname || ':' || description from pg_description where a.attrelid=objoid and a.attnum=objsubid ) end from pg_description where a.attrelid=objoid and a.attnum=objsubid ) as description ";
-    $sql .= " FROM";
-    $sql .= "     pg_class c,";
-    $sql .= "         pg_attribute a left join pg_description e on (a.attrelid=e.objoid and a.attnum=e.objsubid) ";
-    $sql .= " ";
-    $sql .= " WHERE";
-    $sql .= "     (c.relname=?) AND";
-    $sql .= "     (c.oid=a.attrelid) AND";
-    $sql .= "     a.attnum > 0";
-    $sql .= " ORDER BY";
-    $sql .= "     fldnum";
-    $sql .= " ";
-    $arrRet = $objQuery->getAll($sql, array($selectTable)); 
-    */
     $sql = "";
     $sql .= " SELECT column_name, description FROM dtb_table_comment WHERE table_name = ? AND column_name IS NOT NULL";
@@ -294 +275 @@
     $objErr = new SC_CheckError();
     $objErr->doFunc( array("̾¾Î", "name"), array("EXIST_CHECK") );
-    $objErr->doFunc( array("SQLʸ", "sql"), array("EXIST_CHECK") );
+    $objErr->doFunc( array("SQLʸ", "sql", "30000"), array("EXIST_CHECK", "MAX_LENGTH_CHECK") );
     
     // SQL¤ÎÂÅÅöÀ­¥Á¥§¥Ã¥¯

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

@@ -119 +119 @@
     } else {
         
-        sfprintr($error);
         //¥¨¥é¡¼É½¼¨
         $objPage->ERROR = $error;