[PDO] Transaction with select statement?

php@xxxxxxxxxxxxxxx · Sat, 05 Nov 2005 15:15:24 -0000

Hi,

Is it possible to do a transaction with a select statement in PDO?
BEGIN
  INSERT INTO (...) VALUES (...)
  SELECT MAX(id) ....
COMMIT
Because PDO::lastInsertId is not working with all database driver and  
exec() does not return the resultset?
Or can you name which database drivers support lastInsertId?

Regards,
Jochen Vajda

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php