That's correct. If you want that type of functionality you'll have to select all the rows into a cursor and then jump to an absolute position (pageno * rows/page).
A better option might be to let people page through the data like a phonebook. Let them select from all the A's B's, C's etc.
-Mike