KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm accessing a Microsoft Access 2002 database (MDB) using ASP.NET through the OdbcConnection class, which works quite well albeit very slowly. My question is about how to implement pagination in SQL for queries to this database, as I know I can implement the TOP clause as: SELECT TOP 15 * FROM table but I am unable to find a way to limit this to an offset as can be done with SQL Server using ROWNUMBER. My best attempt was: SELECT ClientCode, (SELECT COUNT(c2.ClientCode) FROM tblClient AS c2 WHERE c2.ClientCode <= c1.ClientCode) AS rownumber FROM tblClient AS c1 WHERE rownumber BETWEEN 0 AND 15 which fails with: Error Source: Microsoft JET Database Engine Error Message: No value given for one or more required parameters. I can't work out this error, but I'm assuming it has something to do with the sub-query that determines a rownumber ? Any help would be appreciated with this; my searches on google have yielded unhelpful results :(
Tags (comma-separated)
Save Edits
Cancel