Posted by Steve on 01/29/08 22:50

"AnrDaemon" <anrdaemon@freemail.ru> wrote in message
news:1733708335.20080129235332@freemail.ru...
> Greetings, Ivan Marsh.
>
>>>>>I'm trying to adapt a PHP script that was written to use MySQL, so
>>>>>that it will work with an MSAccess MDB file.
>>>>>
>>>>>An important part of the script makes use of the SQL "LIMIT" keyword
>>>>>available in MySQL. eg: "SELECT MyField FROM MyTable LIMIT 40,10" to
>>>>>select 10 records beginning at the 41st record.
>>>>>
>>>>>Can anyone tell me how I can achieve this same functionality when
>>>>>using ODBC functions to access an MDB file? I think I can set ROWCOUNT
>>>>>(or possibly TOP) to retrieve only 10 records but how do I get it to
>>>>>start at the 41st record?
>>>>
>>>> OK - never mind. Thanks anyway.
>>>>
>>>> I finally figured out the right words to google for and found what I
>>>> was looking for.
>
>>> Care to share?
>
>> SELECT [TOP n] fieldlist FROM tablelist;
>
>> Not exact replacement, but still some help...
>
> To add a word in the topic:
> Solution (and amount of data returned by such query) is depends on Your
> needs.
> I.e. I have started learning PHP by developing a small news feed based on
> MS
> Access dabase.
> And the query
> SELECT TOP 10 * FROM [news_headers] ORDER BY [date] DESC;
> were EXACTLY fits my needs.

but doesn't get the op anywhere since he want records anywhere between the
first and nth...i.e. paged records.

[Back to original message]