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 =
I don't think you need to close the statement and result set between
queries. In fact, I think you shouldn't. Try just having rs.close() and
stmt.close() only once at the end of all the queries.
ChrisC
ps. these are not really tomcat questions
-Original Message-
From: Nicholas Orr
ps. these are not really tomcat questions
Your right, i'll go find a forum.
Thanks anyway
**
The information contained in this e-mail is confidential and is
intended only for the use of the addressee(s).
If you receive this
Oh and I think TYPE_FORWARD_ONLY means the result set is limited in such
a way that each row in the result set may only be visited once and the
result set has to be traversed from front to end. The usual way of doing
this in java is:
rs = stmt.executeQuery(sQuery);
while (rs.next()) {
In some of your code sections, you're trying to accessing values before
advancing the ResultSet to the first row. For example, you have:
stmt = conn.createStatement();
rs = stmt.executeQuery(sQuery);
// Assign values from the database
sSubTitle = rs.getString(SubTitle);
sFormName =
Sorry, this is bit off topic but what is a Newbie Delamere ??
Regards Michael Delamere :-)
- Original Message -
From: Gary Helmling [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Thursday, May 30, 2002 2:26 PM
Subject: Re: Having a Newbie Delamere here.
In some
To: Tomcat Users List
Subject: Re: Having a Newbie Delamere here.
Sorry, this is bit off topic but what is a Newbie Delamere ??
Regards Michael Delamere :-)
**
The information contained in this e-mail is confidential and is
intended
No, I was just wondering :-)
Regards,
Michael
- Original Message -
From: Nicholas Orr [EMAIL PROTECTED]
To: 'Tomcat Users List' [EMAIL PROTECTED]
Sent: Friday, May 31, 2002 12:29 AM
Subject: RE: Having a Newbie Delamere here.
I just let spell check fix my spelling, I was trying
