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]>
