|
|
Posted by Steve on 09/28/69 12:01
"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:7NOdnV7yzoONxgPanZ2dnUVZ_u3inZ2d@comcast.com...
> 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?!!!
>>
>> 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?!!!
>
> No, he's not. Access doesn't have the same capabilities of MySQL. You
> have to work around its limitations.
i think i just misread him, jerry.
Navigation:
[Reply to this message]
|