Still having this problem? I think in here you need to add rs.next() or rs.first() to move to the first row of the ResultSet before you call rs.getString():
if (bPageExists) { sQuery = "SELECT * FROM tblforms WHERE PageOrder = " + iPage; stmt = conn.createStatement(); rs = stmt.executeQuery(sQuery); //ADDED: rs.first(); // Assign values from the database sSubTitle = rs.getString("SubTitle"); sFormName = rs.getString("FormName"); sContent = rs.getString("Content"); iBackPage = iPage - 1; iNextPage = iPage + 1; rs.close(); stmt.close(); } --- Nicholas Orr <[EMAIL PROTECTED]> wrote: > Again coming from the ASP world of doing things. > in ASP you can open a connection to a Database (DB) and execute a > bunch of > queries and do whatever you need to then after you have finished > close the > connection. > > Now I have tried to do this in jsp, but not having much luck. Keep > getting > 'Result set type is TYPE_FORWARD_ONLY' > > Cause In ASP when you start a new ResultSet, after you have closed > the > previous one, (asp equiv = recordset) It automatically goes back to > the > begining as it should, but in jsp it seems to just hang around at > rs.last(). > > !I don't know! > > Well if you could help, I would appreciate it, Source included. > > Regards, > > Nicholas > > > > > ********************************************************************** > The information contained in this e-mail is confidential and is > intended only for the use of the addressee(s). > If you receive this e-mail in error, any use, distribution or > copying of this e-mail is not permitted. You are requested to > forward unwanted e-mail and address any problems to the > MIM Holdings Limited Support Centre. > > For general enquires: ++61 7 3833 8000 > Support Centre e-mail: [EMAIL PROTECTED] > Support Centre phone: Australia 1800500646 > International ++61 7 38338042 > ********************************************************************** > > > ATTACHMENT part 2 application/octet-stream name=LanIDForm.jsp > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>