R S wrote:
I have a screen which displays rows of my table in a paged form (i.e. one can do Back/Previous on them and navigate across pages). I use the rowId of the top and bottom rows to query for the next/previous set of rows in the page. However I just read somewhere that the rowId need not be contigous and this would imply that my paging mechanism is all wrong.
rowId cannot possibly be contiguous under all circumstances. Imagine that you inserted a hundred rows, then deleted one in the middle. That would necessarily create a hole in the contiguous range.
I don't quite see why you need rowId to be contiguous to implement your paging. Can't you do something like this:
select * from mytable where rowId > :lastRowId order by rowId limit 100 Igor Tandetnik