Changeset 5761 for temp/trunk/data

Timestamp:

2006/09/25 16:53:08 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/data/class/SC_Query.php (modified) (1 diff)

temp/trunk/data/class/SC_Query.php

@@ -370 +370 @@
     }   
     
+    function setval($table, $colname, $data) {
+        $sql = "";
+        if (DB_TYPE == "pgsql") {
+            $seqtable = $table . "_" . $colname . "_seq";
+            $sql = "SELECT SETTVAL('$seqtable', $data)";
+        }else if (DB_TYPE == "mysql") {
+            $sql = "ALTER TABLE $table AUTO_INCREMENT=$data";
+        }
+        $ret = $this->conn->getOne($sql);
+        
+        return $ret;
+    }       
+    
     function query($n ,$arr = "", $ignore_err = false){
         $result = $this->conn->query($n, $arr, $ignore_err);