Oh hang on, I'm looking at the Zend_Db_Adapter_Abstract insert method.
The Zend_Db_Table_Abstract insert method calls that:
/**
* Inserts a new row.
*
* @param array $data Column-value pairs.
* @return integer The last insert ID.
*/
public function insert(array $data)
{
$this->_db->insert($this->_name, $data);
// @todo handle tables that have no auto-generated key.
// @todo handle tables that use a named sequence instead
// of an implict auto-generated key.
return $this->_db->lastInsertId();
}
apparently, this function had to be looked at ;)
MF
Maurice Fonk wrote:
That's funny, in the english manual
(http://framework.zend.com/manual/en/zend.db.html#zend.db.adapter.insert)
it says:
"The return value is /not/ the last inserted ID, as the table may not
have an auto-incremented column; instead, the return value is the
number of rows affected (usually 1). If you want the ID of the last
inserted record, call the |lastInsertId()| method after the insert."
That differs from the api documentation?
MF
Alex Netkachov wrote:
Hi,
insert() returns exactly you need.
http://framework.zend.com/apidoc/core/Zend_Db/Table/Zend_Db_Table_Abstract.html#insert
return: The last insert ID.
Sincerely,
On 5/4/07, José de Menezes Soares Neto <[EMAIL PROTECTED]> wrote:
Hi friends,
I am inserting a new record in a DB, but, I would like to retrieve
the ID of
the new record...
How can I do that?
$data = array(
'fun_nome' => $fun_nome,
'fun_cpf' => $fun_cpf,
'fun_cep' => $fun_cep,
'fun_observacoes' => $fun_observacoes,
'fun_data' => date("Y-m-d h:i:s"),
);
$funcionarios = new Funcionarios();
$funcionarios->insert($data);
<------------------------------- here!
best regards,
José de Menezes
--
Maurice Fonk
[EMAIL PROTECTED]
http://naneau.nl/
Scio me nihil scire
