|
|
Posted by Jerry Stuckle on 09/28/46 12:01
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.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|