Changeset 4672 for temp/trunk/data/class

Timestamp:

2006/09/13 11:42:46 (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

@@ -344 +344 @@
     
     function nextval($table, $colname) {
-        $seqtable = $table . "_" . $colname . "_seq";
-        $ret = $this->conn->getOne("SELECT NEXTVAL('$seqtable')");
+        $sql = "";
+        // postgresql¤Èmysql¤È¤Ç½èÍý¤òʬ¤±¤ë
+        if (DB_TYPE == "pgsql") {
+            $seqtable = $table . "_" . $colname . "_seq";
+            $sql = "SELECT NEXTVAL('$seqtable')";
+        }else if (DB_TYPE == "mysql") {
+            $sql = "SELECT last_insert_id();";
+        }
+        
+        $ret = $this->conn->getOne($sql);
         return $ret;
     }