|
|
Posted by AnrDaemon on 01/29/08 20:42
Greetings, Ivan Marsh.
In reply to Your message dated Tuesday, January 29, 2008, 01:53:35,
>>>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?
>>
>> OK - never mind. Thanks anyway.
>>
>> I finally figured out the right words to google for and found what I
>> was looking for.
> Care to share?
SELECT [TOP n] fieldlist FROM tablelist;
Not exact replacement, but still some help...
--
Sincerely Yours, AnrDaemon <anrdaemon@freemail.ru>
Navigation:
[Reply to this message]
|