Posted by Ivan Marsh on 09/28/15 12:01

On Mon, 28 Jan 2008 15:49:15 -0700, Martin wrote:

> On Mon, 28 Jan 2008 14:37:03 -0700, Martin <martinvalley@comcast.net>
> wrote:
>
>>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?

--
I told you this was going to happen.

• Next in forum: Re: how to pass POST variables without a form?
• Prev in forum: Re: login problem
• Thread view: Re: How to use SQL "LIMIT" keyword against an MDB file

[Reply to this message]