Thanks for the info. I have spent considerable time debugging this issue and
that is nice information to know.
Bryan
----- Original Message -----
From: "Atilio Ranzuglia" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 7:30 AM
Subject: Re: Rogue url
| The problem you are facing is because you are using
| JDBC 1.0 drivers. This matter has a solution on JDBC
| 2.0.
|
| Suppose this ResultSet:
| data1-row1 data2-row1
| data1-row2 data2-row2
| data1-row3 data2-row3
|
| On JDBC 1.0 you can ask for data2-row1 but then you
| cannot ask for the previous one (data1-row1). And you
| cannot do first(), last(), previous(),....
|
| On JDBC 2.0 if you declare the ResultSet navigable you
| can call all the methods just named, and also you can
| get the data on one row in any order.
|
| Good luck
| Atilio
|
|
|
| --- Jann VanOver <[EMAIL PROTECTED]> wrote:
| > Yeah, Bryan, I found this one out the hard way, too.
| > Many (most?) db
| > drivers require you to get each field just once and
| > TO GET THEM IN THE SAME
| > ORDER as they appeared in the SELECT statement. It
| > is often advisable to
| > loop through the result set once and save the data
| > into your own class or
| > other data structure.
| >
| > Also, we found out the hard way, that accessing a
| > column BY NAME had SERIOUS
| > performance implications (we were using Weblogics db
| > drivers at the time).
| > We had to get columns by position (getString(1)
| > instead of
| > getString("fldName")) to reach our performance
| > goals.
| >
| > -----Original Message-----
| > From: Bryan LaPlante
| > [mailto:[EMAIL PROTECTED]]
| > Sent: Saturday, July 07, 2001 7:55 AM
| > To: [EMAIL PROTECTED]
| > Subject: Re: Rogue url
| >
| >
| > Call me confused. I have resolved the problem by
| > moving to the top of my
| > ResultSet loop and declaring local variables to hold
| > the value of each
| > column during the loop. The problem seems to be if I
| > use the syntax
| > <%=showdb.getString("anyColumn")%> more than once in
| > the same iteration of
| > the loop it will throw a Java.sql.SQLException. Am I
| > to assume that after a
| > reference to the column value has been made that the
| > ResultSet no longer has
| > that value?
| >
| > What is it that I don't understand here, Anybody?
| >
| > Bryan
| >
| > ----- Original Message -----
| > From: "Bryan LaPlante" <[EMAIL PROTECTED]>
| > To: <[EMAIL PROTECTED]>
| > Sent: Saturday, July 07, 2001 9:16 AM
| > Subject: Rogue url
| >
| >
| > | Hi,
| > |
| > | I need a second pair of eyes on this line of code.
| > I am trying to create
| > an
| > | anchor tag with the following url.
| > |
| > | NewApp.cfm?name=<%= showdb.getString("Name");
| > %>&description=<%=
| > | showdb.getString("Description") %>&appID=<%=
| > | showdb.getString("ApplicationID") %>
| > |
| > | When this line is commented out the loop around it
| > runs fine displaying
| > all
| > | of the ResultSet. When I run this line of code I
| > get a
| > | java.sql.SQLException. Can anybody see what I am
| > doing wrong?
| > |
| > | NT4 sp6
| > | JRun3.0
| > | IIS4
| > |
| > | Bryan LaPlante
| > | 816-347-8220
| > | [EMAIL PROTECTED]
| > | http://www.netwebapps.com
| > | Web Development
| > |
| > |
| >
|
===========================================================================
| > | To unsubscribe: mailto [EMAIL PROTECTED] with
| > body: "signoff
| > JSP-INTEREST".
| > | For digest: mailto [EMAIL PROTECTED] with
| > body: "set JSP-INTEREST
| > DIGEST".
| > | Some relevant FAQs on JSP/Servlets can be found
| > at:
| > |
| > | http://java.sun.com/products/jsp/faq.html
| > | http://www.esperanto.org.nz/jsp/jspfaq.html
| > |
| > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
| > |
| >
| http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
| > |
| >
| >
|
===========================================================================
| > To unsubscribe: mailto [EMAIL PROTECTED] with
| > body: "signoff
| > JSP-INTEREST".
| > For digest: mailto [EMAIL PROTECTED] with body:
| > "set JSP-INTEREST
| > DIGEST".
| > Some relevant FAQs on JSP/Servlets can be found at:
| >
| > http://java.sun.com/products/jsp/faq.html
| > http://www.esperanto.org.nz/jsp/jspfaq.html
| > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
| >
| >
| http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
| >
| >
|
===========================================================================
| > To unsubscribe: mailto [EMAIL PROTECTED] with
| > body: "signoff JSP-INTEREST".
| > For digest: mailto [EMAIL PROTECTED] with body:
| > "set JSP-INTEREST DIGEST".
| > Some relevant FAQs on JSP/Servlets can be found at:
| >
| > http://java.sun.com/products/jsp/faq.html
| > http://www.esperanto.org.nz/jsp/jspfaq.html
| > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
| >
| http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
|
|
| =====
| Ing. Atilio Ranzuglia Buteler
| [EMAIL PROTECTED]
|
| __________________________________________________
| Do You Yahoo!?
| Get personalized email addresses from Yahoo! Mail
| http://personal.mail.yahoo.com/
|
|
===========================================================================
| To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
| For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
| Some relevant FAQs on JSP/Servlets can be found at:
|
| http://java.sun.com/products/jsp/faq.html
| http://www.esperanto.org.nz/jsp/jspfaq.html
| http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
| http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
|
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
