[PHP-DEV] PHP 4.0 Bug #8407 Updated: set rowcount n will return no result From: fmk <email protected>
Date: 01/04/01

ID: 8407
Updated by: fmk
Reported By: steeven <email protected>
Old-Status: Open
Status: Closed
Bug Type: MSSQL related
Assigned To:
Comments:

You will need to execute this in three statements. You are sending tree statements and the last does not return any data so the result will be empty.

Previous Comments:
---------------------------------------------------------------------------

[2000-12-24 12:20:17] steeven <email protected>
$q="
set rowcount 5
select * from tbl
set rowcount 0
";
$r= mssql_query($q);

$r will be empty!

$q="select TOP 5 * from tbl ";
this will work.

---------------------------------------------------------------------------

Full Bug description available at: http://bugs.php.net/?id=8407 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>