Posted by Paul Lautman on 01/30/08 22:43

Ivan Marsh wrote:
> On Wed, 30 Jan 2008 14:10:02 -0600, Steve wrote:
>>
>> SELECT *
>> FROM
>> (
>> SELECT (
>> SELECT COUNT(*)
>> FROM companies AS r
>> WHERE r.Company < co.Company
>> ) AS RowNum ,
>> co.Company AS Company ,
>> co.Name AS Name ,
>> co.Region AS Region
>> FROM companies AS co
>> )
>> WHERE RowNum BETWEEN 50 AND 100 ORDER BY RowNum
>
> ...and have you verified that any of this works with PHP/ODBC hitting
> a MDB file?
He may not have bothered since he doesn't actually want to do it himself.
However, since it is indeed Microsoft's advice of how to do it, they may
well have.

• Next in forum: Re: curl attack prevention
• Prev in forum: Re: How to use SQL "LIMIT" keyword against an MDB file
• Thread view: Re: How to use SQL "LIMIT" keyword against an MDB file

[Reply to this message]