Hi,
You should wirte result.next() as the fisrt statement.
The modified version of your code is as follows:-
<HTML> .
<BODY>
<%@ page import="java.sql.*" %>
<%! String dbURL="jdbc:odbc:bdayorcl";
String dbCon="sun.jdbc.odbc.JdbcOdbcDriver";
ResultSet result=null;
%>
<jsp:useBean id="dbbean" class="db.DbBean" scope="session">
<jsp:setProperty name="dbbean" property="*"/>
</jsp:useBean>
<HR>
<BR><BR>
<% try{ dbbean.setDbDriver(dbCon);
dbbean.setDbURL(dbURL);
dbbean.connect();
result=dbbean.execSQL("select * from dept");
%>
<h2 align=center>Tables Available :</h2>
<p><center> <select name=table size=15>
<% while(result.next()) // here i made the correcitons
%>
<option><%=result.getString(2)%></option>
<%
}
%>
</select></center></p>
<p><center><input type=submit value=Ok name=B1 style=width:80></center></p>
<% result.close();
dbbean.close();
}catch(SQLException e)
{ throw new ServletException(e);
}
%>
</BODY>
</HTML>
----- Original Message -----
From: Sanjay Gomes <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 29, 2000 6:20 PM
Subject: Problem displaying data in list box thro jsp
> I want to display my results into a listbox which I am unable to do so it
> gives invalid cursor state
>
> I tried the same code that I had used for displaying the contents of a
table
> ,with the neccessary changes
> for displaying it in a listbox
> Please can anybody give a hint as to what could be the problem .
>
>
> <HTML> .
> <BODY>
> <%@ page import="java.sql.*" %>
> <%! String dbURL="jdbc:odbc:bdayorcl";
> String dbCon="sun.jdbc.odbc.JdbcOdbcDriver";
> ResultSet result=null;
> %>
> <jsp:useBean id="dbbean" class="db.DbBean" scope="session">
> <jsp:setProperty name="dbbean" property="*"/>
> </jsp:useBean>
> <HR>
> <BR><BR>
> <% try{ dbbean.setDbDriver(dbCon);
> dbbean.setDbURL(dbURL);
> dbbean.connect();
> result=dbbean.execSQL("select * from dept");
> %>
> <h2 align=center>Tables Available :</h2>
> <p><center> <select name=table size=15>
> <option><%= result.getString(2)%>
> <% while(result.next())
> { %>
> <option><%=result.getString(2)%>
> <% } %>
> </select></center></p>
> <p><center><input type=submit value=Ok name=B1
style=width:80></center></p>
> <% result.close();
> dbbean.close();
> }catch(SQLException e)
> { throw new ServletException(e);
> }
> %>
> </BODY>
> </HTML>
>
> P.s- the bean works since I tried it with my other code n works fine
>
> TIA
> Sanjay
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>
===========================================================================
> 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
