Problem with CURSOR under MS SQL 7

Hi, I'm trying to understand why something like this: DECLARE crs CURSOR KEYSET FOR SELECT title FROM article WHERE pub_id = 1 OPEN crs FETCH ABSOLUTE 3 FROM crs DECLARE @var INT SET @var = 0 WHILE (@var<10) BEGIN FETCH NEXT FROM crs SET @var = @var +1 END CLOSE crs DEALLOCATE crs Doesn't work when you try to embend it in a PHP/MSSQL query!? There's something that I doesn't mind about this? Maybe a LOCAL PROCEDURE works better? What I have to do is just emulate the LIMIT function that MySQL have in his set of command. This function is very useful when you have to extract only a set of row from the query with an absolute start position. THANKS A LOT Mauro -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net For additional commands, e-mail: php-windows-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net