|
|
Posted by Jerry Stuckle on 01/29/08 19:48
Steve wrote:
> "Ivan Marsh" <annoyed@you.now> wrote in message
> news:pan.2008.01.29.16.23.04.896088@you.now...
>> 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.
>
> hmmm, then you're still crazy. :)
>
> the db should be used to return *only* the data needed. there should be
> nothing for you to have to strip out. what consitutues 'data needed' for the
> op are only the records between x and n. getting all the records and
> stripping out everything but x through n using php is ludicrous.
>
>
>
Steve,
That's great when the DB gives you the tools to do so. Unfortunately,
Access is nowhere nearly as advanced as MySQL.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|