[ADodb-general] MSSQL stored procedure

[Paul T. <Pa...@gu...>]

Using this code to run a mssql stored procedure.

 

                                function Upload($intFairFromID = 0,
$intFairToID = 0, $bolAttend = 0, $bolCancelled = 0) {

                                                $arrResult =
array('Total' => 0, 'Upload' => 0, 'Duplicate' => 0, 'Cancel' => 0,
'Result' => 0);

 

                                                $strSQL =
'UPLOAD_FAIR_VISITORS';

                                                $objSP =
$this->conn->PrepareSP($strSQL);

 
$this->conn->Parameter($objSP, $intFairFromID, 'FairFromID');

 
$this->conn->Parameter($objSP, $intFairToID, 'FairToID'); 

 
$this->conn->Parameter($objSP, $bolAttend, 'Attend'); 

 
$this->conn->Parameter($objSP, $bolCancelled, 'Cancelled');

 
$this->conn->Parameter($objSP, $arrResult['Total'], 'Total', true); 

 
$this->conn->Parameter($objSP, $arrResult['Upload'],'Upload', true); 

 
$this->conn->Parameter($objSP, $arrResult['Duplicate'],'Duplicate',
true); 

 
$this->conn->Parameter($objSP, $arrResult['Cancel'],'Cancel', true); 

 
$this->conn->Parameter($objSP, $arrResult['Result'],'Result', true);

 

 
$this->conn->Execute($objSP);

 

                                                return $arrResult;

                                }

 

I would expect $arrResult to contain the output values from the stored
procedure, but it contains all Zeros. What am I doing wrong??