Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 48825475B47 for ; Tue, 24 Dec 2002 07:57:46 -0500 (EST) Received: from virtual1.giganet.nl (tarantula.giganet.nl [212.125.143.1]) by postgresql.org (Postfix) with ESMTP id 4F3E3475843 for ; Tue, 24 Dec 2002 07:57:45 -0500 (EST) Received: from artemis.cuci.nl (artemis.cuci.nl [212.125.128.9]) by virtual1.giganet.nl (BuGless_3.01) with ESMTP id gBOCvm628103 for ; Tue, 24 Dec 2002 13:57:48 +0100 Received: from adlsa (adlsa.cm.cuci.nl [10.1.12.174]) by artemis.cuci.nl (BuGless_3.01) with ESMTP id gBOCvk2C012966 for ; Tue, 24 Dec 2002 13:57:47 +0100 Message-Id: <200212241257.gBOCvk2C012966@artemis.cuci.nl> Received: from Spooler by adlsa (Mercury/32 v3.32) ID MO000074; 24 Dec 02 13:57:56 +0100 Received: from spooler by arbodienst-limburg.nl (Mercury/32 v3.32); 24 Dec 02 13:57:38 +0100 From: "Jules Alberts" Organization: ARBOdienst Limburg BV To: pgsql-php@postgresql.org Date: Tue, 24 Dec 2002 13:57:24 +0100 MIME-Version: 1.0 Subject: AdoDB: how to determine OID of inserted row with Execute() Reply-To: jules.alberts@arbodienst-limburg.nl X-mailer: Pegasus Mail for Windows (v4.02a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/54 X-Sequence-Number: 1729 Hello everyone, I'm using AdoDB to create a PHP interface to a PostgreSQL db. I have a problem when inserting a row. I do something like this: connect_to_db(); $return = $db->Execute("insert into foo values ('bar')); if ($return === false) { echo $db->ErrorMsg(); } else { show_row($oid) // here's the problem } When I do a succesful INSERT in pgsql, the OID of the inserted row is echoed. However, according to the manual, the Execute() method allways returns a recordset. I did a serialize() on $return to see if the OID is there somewhere, but it isn't. I need the OID to be able to display the row (with show_row()) after it's inserted. Does anybody know how to determine the OID of an INSERTed row when using AdoDB? TIA!