Stored Procedures w/ MSSQL via ADODB

admin

Administrator
Staff member
I need to call a stored procedure in php to a mssql database. The stored procedure does not return a recordset but I need to read one of the out values.

The following vb script works (not complete code) and msgbox's me the right value:
<--snip-->
Set tx = cmd.Parameters("@p_claimtype")
tx.Value = "COMP"
Set tx = cmd.Parameters("@p_category")
tx.Value = 1
cmd.Execute
Set tx = cmd.Parameters("@c_name")
MsgBox tx.Value

But the following php does not; it echo's nothing:
$tx = $cmd -> Parameters('@p_claimtype');
$tx->Value = 'COMP';
$tx = $cmd -> Parameters('@p_category');
$tx->Value = 1;

$cmd->Execute();
$tx = $cmd -> Parameters('@c_name');
echo $tx->Value;


I'm looking for ideas on how I can do this without using the cvs version of php (which has mssql_bind())

Anyone?

Thanks,
Tom
 
Back
Top