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]
--
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]
