|
|
Posted by Steve on 01/30/08 17:34
"NC" <nc@iname.com> wrote in message
news:093fa743-0beb-4582-b9e2-8baaf8531f0b@s37g2000prg.googlegroups.com...
> On Jan 28, 1:37 pm, Martin <martinval...@comcast.net> 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.
>
> Good luck...
>
>> 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?
>
> You can't. Access does not support LIMIT clauses.
BULLSHIT !!!
*acheive ... functionality*...the two key words. i've given an explanation
of at least one way...which falsifies your claim, btw.
> The closet thing you can do is to run this query:
>
> SELECT TOP 50 MyField FROM MyTable
BULLSHIT !!!
> and then loop through first 40 records returned without doing
> anything and start your processing from the 41st record.
more lunacy.
Navigation:
[Reply to this message]
|