Re: [PHP] How to get stored procedure return values via PDO?

I had a similar problem using PDO on MS Sql Server where I was trying to return the id of an inserted row. I ended up giving up and doing a second query to get @@IDENTITY. Regards, Bruce Richard Davey [EMAIL PROTECTED] 27/07/2007 12:51 a.m. Hi, I'm calling a MySQL Stored Procedure via PDO

[PHP] How to get stored procedure return values via PDO?

Hi, I'm calling a MySQL Stored Procedure via PDO (PHP 5.2.3) $stmt = $dbh-prepare('CALL forum_post(?, ?, ?, ?, ?, @status, @thread_id, @message_id)'); At the moment in order to get the values of status, thread_id and message_id I need to issue a second query: $sql = SELECT @status AS status,