Re: [ADodb-general] MSSQL stored procedure

[Alfredo Y. <alf...@gm...>]

>From the manual:

"in the mssql driver, preparing stored procedures requires a special
function call, mssql_init( ). "

Also, you may try with simple variables as parameters, not using an array.

Greetings,



On Wed, Oct 8, 2008 at 9:57 AM, Paul Tugwell <Pa...@gu...> wrote:

>  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??
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> ADodb-general mailing list
> ADo...@li...
> https://lists.sourceforge.net/lists/listinfo/adodb-general
>
>


-- 
Alfredo Yong
Sistemas web