FreeTDS Development Group

[ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>]

> 
> Sorry about asking this simple question. I searched the archives
> and could not find what I needed.
> 
> I need a simple php example of calling a mssql stored procedure that
> has an output parameter (NOT using mssql_init,mssql_bind or 
> mssql_execute).
> 
> Can someone help out?
> 
> lance
> 
> 
> Business Quality Web Email,
> Group Scheduling, & Team Tools
> http://www.norada.com/save
> 
For now store procedure handling are not supported directly.

But this can be done with work-around

Consider

CREATE PROCEDURE sp_Test
        @i INT OUTPUT
AS
        SET @i = 10
GO

You can call procedure with following statement

DECLARE @res INT
EXEC  sp_Test @res OUTPUT
SELECT @res

and read result of store procedure with fetch

freddy77

=================================
"STRICTLY PERSONAL AND CONFIDENTIAL

This message may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.
The contents of this message that do not relate to the official business of
our company shall be understood as neither given nor endorsed by it."

=================================