Re: DB_Object->insert() not returning ID

From: Date: Mon, 15 Nov 2004 18:46:12 +0000
Subject: Re: DB_Object->insert() not returning ID
References: 1 2  Groups: php.pear.general 
Request: Send a blank email to pear-general+get-15528@lists.php.net to get a copy of this message
On Sun, 14 Nov 2004 21:23:06 -0800, Ken Restivo <ken@restivo.org> wrote: > On Sun, Nov 14, 2004 at 07:36:41PM -0800, Ken Restivo wrote: > > One more: inserts succeed but always return 1 as an ID. > > > > I supposed I can hack around this with a raw query for last_insert_id(), but the docs say > > insert() should return this. > > > > OK well I did this, but I'm still kind of suspicious about why I had to: > > function lastInsertID($obj) > { > $db =& $obj->getDatabaseConnection(); > > $data =& $db->getOne('select last_insert_id()'); > if (DB::isError($data)) { > die($data->getMessage()); > } > return $data; > } > Looking at the DB_DataObject code, insert() says it returns true, false, or 0. Looks like the online docs are wrong. Look at the online API docs. -- Justin Patrin

« previous php.pear.general (#15528) next »