>>> Robert Pimentel <[EMAIL PROTECTED]> 9/29/99 8:19:56 PM >>>
>This is an off-topic question..just kidding..you can put away your
.38 special... ;)
Bang.
>As you can see I'm attempting to control my select
>statement based on the most recent rowid (which
>I stored as a session object). I'm guessing there
>must be a better way to go about doing this. I've
>looked over the archives, and there seems be mention
>of hidden fields, Vectors,etc.. Which might be the
>best approach for what I'm trying to
>accomplish? (control a resultset)
The trouble is, unless you're using JDBC 2, there isn't a way to roll
backwards through the RS.
It seems to me you're doing everything correctly.
I wrote a class some time ago, to mainpulate resultsets. It worked by
caching the entire resultset and allowing the user to select which row
was required. It also had the concept of a current row.
This worked quite well for small RS but obviously large ones more
more of a pain.
If you're interested I could mail you the source.
Nic
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
