|
|
Posted by Ivan Marsh on 01/29/08 16:23
On Mon, 28 Jan 2008 17:08:29 -0600, Steve wrote:
> "Ivan Marsh" <annoyed@you.now> wrote in message
> news:pan.2008.01.28.22.40.54.715306@you.now...
>> On Mon, 28 Jan 2008 16:09:32 -0600, Steve wrote:
>>
>>
>>> "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?!!!
>>
>> 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?
>
> let me assure you, if you pull even 2MB of data into an array just to
> pseudo-query (i.e. removed unwanted data) then you're not using your
> tools wisely. the only thing that should be returned from ANY db is
> *just* the data you want...nothing more.
Indeed. "All the records" in my above statement should be read "All the
records needed" not "The entire dataset". The odbc_exec query should be
used to produce the smallest dataset possible and then strip out the data
not needed.
--
I told you this was going to happen.
Navigation:
[Reply to this message]
|