Re: How to use SQL "LIMIT" keyword against an MDB file

On Mon, 28 Jan 2008 16:09:32 -0600, Steve wrote:


"Ivan Marsh" <annoyed@xxxxxxx> wrote in message
news:pan.2008.01.28.21.50.48.197643@xxxxxxxxxx
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.

are you out of your fucking mind?!!!

I assure you I'm not... though I don't claim to be Mr. Grand Wizard PHP
Programmer Guy.

yeah, let me pull all the records from my 55 million rowed table into a
php array...

Can you fit 55 million rows in an Access database that's less than 2 gigs?

THEN strip out the unwanted ones from the array. hell, let's just put
the records into a text file and pull them from there...build our own
php query functionality for the file. while we're at it, we'll run our
lil 'query' in a loop. and, for good measure...

You may very well have to do that. Like I said: You/He just lost an
enormous amount of functionality.

you've got to be fucking kidding...right?!!!

No... An Access MDB file would simply be the wrong tool for the job unless
you're dealing with a very small dataset.

Without a LIMIT function you have to query for the matching records with
odbc_exec and then eliminate the unwanted data from the result set or move
the wanted data to a new array. I don't know of any way of doing it at
query time... and while I was looking into it when I had to use a dBase
file as a backend for a project it was apparent that no one else did
either.

If you have a run-time solution please share it with the group. I could
sure use it.

--
I told you this was going to happen.

.

Quantcast