Hello Mauro,
I don't know exactly why your Cursor doesn't work (e.g. a SET ..... desn't work
yet also, but will be in the next version).
Since you just want simulate the LIMIT (x,y) from mySQL, here's the way I've
done it (Simple "countermove-Select"):
SELECT TOP $limit WITH TIES * FROM $table WHERE $check2 ID_Fa not in
(SELECT TOP $offset WITH TIES ID_Fa FROM $table WHERE $check1 ORDER BY $mySort1
ASC, ID_Fa ASC)
ORDER BY $mySort1 ASC, ID_Fa ASC"
Hope that helps,
Thomas
"Mauro Boschi (by way of Mauro Boschi )" wrote:
> 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]
--
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]
