Hi,
Is there a way to scroll thru a list of items with a multi-part index. I cannot use a cursor because I am executing in a stateless session bean and I will be returning to the user parts of the list as they scroll through it.

Is there a straight forward way to do this. I am using an index consisting of multiple fields, so keeping track of the last item the user saw and re-issueing the select statement will not work, because lower order fields might have greater values than higher order fields.

Conceptually this is simple...scrolling through a list, but since I cannot keep the cursor open in between screen displays, I do not see a clean way of doing this

thanks,
Adam

let me add to my siduation , because the normal SetFirstRow/SetMaxResults cannot apply. On a single web page there might be multiple list the user is paging through and thus I cannot keep the session open to achieve my desired scrolling, because there isn't way to associate an open session with a particular open cursor ( ScrollableResults ).
Also, there might be maintenance going on and the data might get stale, so doing the 'normal' SetFirstRow/SetMaxResults doesn't apply

thanks...