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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
