Re: How to use SQL "LIMIT" keyword against an MDB file
- From: Ivan Marsh <annoyed@xxxxxxx>
- Date: Mon, 28 Jan 2008 15:50:48 -0600
On Mon, 28 Jan 2008 14:37:03 -0700, Martin 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?
You just lost an enormous amount of functionality. I'm assuming this is
something you had to do.
Pull all of the records and then programatically strip out the records you
don't want from the array.
--
I told you this was going to happen.
.
- Follow-Ups:
- References:
- How to use SQL "LIMIT" keyword against an MDB file
- From: Martin
- How to use SQL "LIMIT" keyword against an MDB file
- Prev by Date: How to use SQL "LIMIT" keyword against an MDB file
- Next by Date: Re: how to pass POST variables without a form?
- Previous by thread: How to use SQL "LIMIT" keyword against an MDB file
- Next by thread: Re: How to use SQL "LIMIT" keyword against an MDB file
- Index(es):
Relevant Pages
|
