Posted by Martin on 09/28/55 12:01

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.

• Next in forum: CRUD tool to manage a single table?
• 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]