Kai Hackemesser wrote:
> Hi!
>
> I have found that I can't ask the same Recordset field two times with
> getString() or equals. I get the SQL exception "no Data" on second try. Is
> this a rule or a mistake on my side?
>
> here is some code where it happens:
>
> try {
> String RSTB3000_Query = "SELECT ROUTING_AREA FROM TRADIUS.RSTB3000";
> rs = stmt.executeQuery(RSTB3000_Query);
> while(rs.next())
> {
> String selektiert = "";
> String Typ = rs.getString("ROUTING_AREA");
> if (Typ == "AGB ")
> {
> selektiert = " selected";
> }
> out.println("\t\t\t\t<option value=\"" + Typ + selektiert
> + "\">" + Typ);
> }
> rs.close();
> } catch(SQLException ex) {
> out.println("SQLException: " + ex.getMessage());
> }
>
> As you can see, I now create a String variable 'Typ' with the content of
> ROUTING_AREA, for not getting that error, but if I replace 'Typ' with
> rs.getString("ROUTING_AREA"), after second appearance I got 'no data'.
>
> ===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
> 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".
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
