Re: Re: DataObject compatibility

Mika Tuupola wrote:

On Fri, 27 Jun 2003, Markus Wolff wrote:

If I understand the code right, all I need to do is add the modifyLimitQuery() method to PEAR::DB´s MSSQL driver class to make it work, is that correct? If so, I think I know a way to make limit() work with MSSQL as well.

Not correct (AFAIK). MSSQL has the TOP keyword instead of LIMIT but that does not support offset. Thus PEAR DB does not have modifyLimitQuery() for MSSQL driver. However PEAR DB already does have working support for LIMIT in MSSQL driver via emulation. You can call it by using limitQuery().

You´re right, the TOP syntax doesn´t support an offset, neither is there any other method for that in MS SQL Server... why was it again this thing is so expensive? ;-) Well, one way or another, I need this - so I´ll just try around a little and see which way it´ll be in the end. Thanks for the tip with limitQuery(), will try that! Regards, Markus