Menu
Community /Pin to ProfileBookmark
@NogDogJun 30.2010 — #From the DB side, the only thing I know of is the TOP command in MS Access, which is more or less the same as LIMIT, but it does not appear to have a corollary to OFFSET. Other than porting it over to a "real" DBMS ( ? ), all I can think of is to query all, perhaps using TOP to stop it after it would get all that page's records (essentially the TOP value would be LIMIT [i]plus[/i] OFFSET), then if the PHP DB extension you're using has some sort of record seek function, use that to jump to the "offset" result row, otherwise do a loop with a counter on the results, skipping each until the counter reaches the desired offset (which seems pretty ugly if you will be dealing with lots of matching rows in the DB query).@NogDogJul 01.2010 — #To copy from Access to MySQL, would something like this work, do you think? (I don't have Access to try it.)
Process those 100 records into the MySQL DB, then:
Reiterate until all Access records have been processed in groups of 100 (or whatever increment you prefer).
Paginating data from MSaccess in PHP
Hi All,
Many of you may be aware there microsoft access does not support LIMIT in queries.
I have msaccess database table that has around 82000 records.I need to paginate these records.
Could anyone help me to write a query that would suffice the same.
Regards,
Santhosh
Sign in
to post a comment5 Comments(s) ↴
0
@NogDogJun 30.2010 — #From the DB side, the only thing I know of is the TOP command in MS Access, which is more or less the same as LIMIT, but it does not appear to have a corollary to OFFSET. Other than porting it over to a "real" DBMS ( ? ), all I can think of is to query all, perhaps using TOP to stop it after it would get all that page's records (essentially the TOP value would be LIMIT [i]plus[/i] OFFSET), then if the PHP DB extension you're using has some sort of record seek function, use that to jump to the "offset" result row, otherwise do a loop with a counter on the results, skipping each until the counter reaches the desired offset (which seems pretty ugly if you will be dealing with lots of matching rows in the DB query).0
@NogDogJul 01.2010 — #To copy from Access to MySQL, would something like this work, do you think? (I don't have Access to try it.)<i>
</i>SELECT TOP 100 * FROM table;
Process those 100 records into the MySQL DB, then:
<i>
</i>DELETE TOP 100 FROM table;
Reiterate until all Access records have been processed in groups of 100 (or whatever increment you prefer).