How to call output param with yii

Yii 1.1 General Discussion
1

i have function code like this.




$custId = Yii::app()->user->name;

 $command = Yii::app()->db->createCommand("declare @transactionNumber nvarchar(11); exec spSetCustomerTransaction '$custId', @transactionNumber output; select @transactionNumber = TransactionNumber from CustomerTransactions where TransactionNumber = @transactionNumber");

            $command->execute();

            echo @transactionNumber;

this code run succesfull but i can’t call result output parameter in my view.

how i call or echo this output??

thanks…

2

Hello.

If for example your function is called "myFunction", you could do this:

1- Your function:




function myFunction()

{

....

    return @transactionNumber;

....

}

2- Into your view:




...

echo myFunction();

...

Regards.