We help IT Professionals succeed at work.

Retrieving rows from a resultset (ACCESS-JSP)

vrm1020
vrm1020 asked
on
Medium Priority
357 Views
Last Modified: 2012-06-27
How to get a particular row from a resultset based on the row position in the resultset. For eg. if
we have 100,000 rows in a resultset and i want to retrieve rows from 50,001 to 50239 directly, without
scrolling upto the 50000th  record.
Presently this is done using ACCESS as Backend and JSP as the frontend page.

Thankyou.
Comment
Watch Question

Why do you have such a large number of rows comming back, if you only want a (relativly) small number of them. Why can you not refine your query?

If this is not possible, does Access have a ROW_ID variable like some other databases? (which could be the basic, or at least an additional clause to a query?)

GR.

Commented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

-Points for  googlyralph

Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
Venabili
EE Cleanup Volunteer

Explore More ContentExplore courses, solutions, and other research materials related to this topic.