posted 10 years ago
For getting all records in a table it's "select count(*) from table". You currently have the actual data returned.
For the fetching, depends on what DB you use. If you use say MySQL, you can use the LIMIT clause. If you use Oracle then rownum can be used but can't guarantee if the data order is the same every time.
You most likely need to store the from and to variables in some request attributes or something.
K. Tsang CEng MBCS PMP PMI-ACP OCMJEA OCPJP