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
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