Re: php_mssql70.dll Access Denied

From: Date: Wed, 10 Jan 2001 05:54:04 +0000
Subject: Re: php_mssql70.dll Access Denied
References: 1  Groups: php.windows 
Request: Send a blank email to php-windows+get-4896@lists.php.net to get a copy of this message
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

« previous php.windows (#4896) next »