[freetds] Output parameters
ZIGLIO, Frediano, VF-IT
Frediano.Ziglio at vodafone.com
Wed Apr 23 10:37:45 EDT 2008
>
> Hi,
>
> I'm having a problem getting my output parameters returned in PHP from
> an sql server stored procedure. This is the code used, it is fairly
> straightforward:
>
> $canLogin = 666;
> $websiteID = 2;
>
> $sp = mssql_init('sp_web_WebsiteEnabled');
> mssql_bind($sp, '@WebsiteID', $websiteID, SQLINT4, false); // INT
> mssql_bind($sp, '@Enabled', $canLogin, SQLINT1, true); // TINYINT
> (OUTPUT)
> mssql_execute($sp);
>
> // $canLogin is still 666
>
>
> I'm using freetds 0.64 with PHP 5.2.0 and Microsoft SQL
> Server 2000. My
> freetds.conf file has tds version 8.0 (7.0 doesn't work either). The
> apache server is running on freeBSD.
>
> Do you need to compile with special options to get output
> parameters to
> work for SQL Server 2000? I think RETVAL is also not working but I'd
> need to test to make sure.
>
> What could be the problem? The PHP version? FreeTDS setup? SQL Server
> version?
>
> Kind regards,
> Gunther
Are you sure store does not return any output?? mssql return output
parameters after all data (rows, errors and so on) are sent. For
instance it can happen that a simple select or an insert return some
token that delays output parameters.
freddy77
More information about the FreeTDS
mailing list