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
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.
>
002 10:50 PM
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-ma
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
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 =
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()) {
>>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 e
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