Can PHP's SQL Server driver return SQL return codes?

Question

Stored procs in SQL Server sometimes finish with a return code, as opposed to a recordset of data. I've seen ASP code that's able to get this return code, but I can't figure out how to get this code with PHP's mssql driver.

mssql_get_last_message() always returns nothing, and I'm thinking it's because it only returns the very last line that came from the server. When we run the proc in another application (outside PHP), there is blank line following the return code.

Has anyone figured out how to get return codes from SQL stored procs using PHP's mssql driver?

Matt Rogish · Accepted Answer · 2008-09-25 20:59:23Z

2

Are you talking about SQL Server error codes, e.g. RAISERRROR or other failures? If so, last time I checked in PHP you need to ask for @@ERROR (e.g. select @@error) instead.

If it is a return code, you must explicitly catch it, e.g.

DECLARE @return_code INT
EXEC @return_code = your_stored_procedure 1123
SELECT @return_code

edited Sep 25, 2008 at 20:59

answered Sep 25, 2008 at 20:46

Matt Rogish

25k11 gold badges79 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mez · Accepted Answer · 2008-09-25 20:48:03Z

0

To get a numeric error code from mssql you can do a select that looks something like

SELECT @@ERROR AS ErrorCode

Which SHOULD return the correct error code.

answered Sep 25, 2008 at 20:48

Mez

25k14 gold badges75 silver badges93 bronze badges

Collectives™ on Stack Overflow

Can PHP's SQL Server driver return SQL return codes?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related