Hello all,
An example of a familiar SQL syntax I use in other DBs is:
This uses the "LIMIT {offset},{rows}" syntax, meaning my SELECT query only returns 10 rows from the table, starting at the 10th row. LIMIT 50,25 would return 25 rows starting at the 50th row. (Or some DBs use "LIMIT {rows},{offset}"
This is very useful if you want to display "pages" of records, with a certain number of records per page, with a button to show "Next 10 records", etc... (I'm not using the Access front end, just making an ODBC connection from the PHP/webserver environment)
Is there any direct way to accomplish this with an Access query? Or can anyone show how they would accomplish this for web pages with ASP?
An example of a familiar SQL syntax I use in other DBs is:
Code:
SELECT * FROM myTable LIMIT 10,10This uses the "LIMIT {offset},{rows}" syntax, meaning my SELECT query only returns 10 rows from the table, starting at the 10th row. LIMIT 50,25 would return 25 rows starting at the 50th row. (Or some DBs use "LIMIT {rows},{offset}"
This is very useful if you want to display "pages" of records, with a certain number of records per page, with a button to show "Next 10 records", etc... (I'm not using the Access front end, just making an ODBC connection from the PHP/webserver environment)
Is there any direct way to accomplish this with an Access query? Or can anyone show how they would accomplish this for web pages with ASP?
