[Solar-talk] lastInsertId() not working with MySql?

[Paul M Jones]

On Mar 29, 2007, at 12:51 PM, Rodrigo Moraes wrote:

>> Based on this news, would it be OK for me to close the related ticket
>> in Trac?
>
> Totally OK. my adapter was re-setting the charset on every call to  
> _connect():
>
>     $this->_pdo->exec('SET CHARACTER SET ' . $this->_config 
> ['charset']);
>
> I guess this exec, executed in the middle of a insert() and a
> lastInsertId(), also resets the last inserted id. I think any exec
> would do this, right?

I would think so too.



--

Paul M. Jones  <http://paul-m-jones.com>

Solar: Simple Object Library and Application Repository
for PHP5.   <http://solarphp.com>

Savant: The simple, elegant, and powerful solution for
templates in PHP.   <http://phpsavant.com>