|
|
Posted by Steve on 09/28/72 12:01
"Ivan Marsh" <annoyed@you.now> wrote in message
news:pan.2008.01.28.21.50.48.197643@you.now...
> 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?!!!
yeah, let me pull all the records from my 55 million rowed table into a php
array...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've got to be fucking kidding...right?!!!
Navigation:
[Reply to this message]
|