Hey Guys,
I'm working with a SQL Server stored procedure that returns error codes;
here is a very simple snippet of the SP.
DECLARE @ret int
BEGIN
SET @ret = 1
RETURN @ret
END
I can't figure out how to access the return value in PDO; I'd prefer not to
use an OUT parameter, as alot of these Stored Procedures have already been
written. Here is an example of how I am currently calling the procedure in
PHP.
$stmt = $this->db->prepare("EXECUTE usp_myproc ?, ?");
$stmt->bindParam(1, 'mystr', PDO::PARAM_STR);
$stmt->bindParam(2, 'mystr2', PDO::PARAM_STR);
$rs = $stmt->execute();
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
Is there a way to do this without an OUT parameter?
|