Hi, I think the following may be the source of your problem:
'rs.getString(2)+">"+rs.getString(2));' . Try getting this value once, then
put it in a String object. Now you can substititute 'rs.getString(2)' for
whatever object you declared. So it may look like this:
'stringobj+">"+stringobj;'
*Antonio*
----- Original Message -----
From: sanjeev kumar <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 04, 1999 7:49 AM
Subject: urgent help reqd for IndexArrayOutOfBoundException
> I hv been developing a database access application thru servlets. I hv one
> combo box with data obtained from database. Now the second combo-box
should
> hv data based on the selection in first combo-box or in other words should
> be filtered. The application meets IndexArrayOutOfBound exeception on run.
>
>
> package budget;
>
> import java.io.*;
> import java.sql.*;
> import javax.servlet.*;
> import javax.servlet.http.*;
>
> public class expentry extends HttpServlet {
> String dbaseserver="172.16.1.50";
> String drv="ids.sql.IDSDriver";
> String jdbcurl="jdbc:ids://" + dbaseserver+
> ":12/conn?dbtype=odbc&dsn=BUDGET";
> ResultSet rs,rs1,rs2;
> Statement st,st1,st2,st3;
>
>
> public void init()throws ServletException{
> super.init();
> }
>
> public void doGet(HttpServletRequest req,HttpServletResponse
res)throws
> ServletException,IOException{
>
> PrintStream out;
> Connection conn;
>
> out=new PrintStream(res.getOutputStream());
> res.setContentType("text/html");
> out.println("<html><head><title>Expenditure Entry
> Screen</title></head>");
> out.println("<script language=javascript>");
> out.println("function selzn(n){");
>
> out.println("document.forms[0].submit();");
> out.println("}</script>" );
>
> out.println("<body>");
>
> out.println("<form >");
> try{
> Class.forName(drv);
> conn=DriverManager.getConnection(jdbcurl);
>
> file://Combobox for zone
> st=conn.createStatement();
> rs=st.executeQuery("select * from zone");
> out.println("Select Zone:");
> out.println("<select name=cmbzone
> onChange='selzn(this.selectedIndex)';>");
> while(rs.next()){
> out.println("<option value=" +
> rs.getString(2)+">"+rs.getString(2));
> }
> out.println("</select>");
> out.println("<br>");
> file://Combobox for station
> --------------->Problem area
> String stnsql="SELECT STATION.[STATION_ NAME] FROM STATION WHERE
> STATION.ZONE='"+ req.getParameter("cmbzone")+"'";
> out.println(stnsql);
>
> st=conn.createStatement();
> rs=st.executeQuery(stnsql);
> out.println("Select Station:");
> out.println("<select name=cmbzone>");
> while(rs.next()){
> out.println("<option>"+rs.getString(2));
> }
> out.println("</select>");
> out.println("<br>");
>
>
>
> }
> catch(SQLException ex){
> out.println("SQL Exception caught");
> out.println("Message:" +ex.getMessage());
> }
> catch(ClassNotFoundException e){
> out.println("<hr><h3>ClassNotFoundException caught</h3>");
> out.println("Message:" + e.getMessage());
> }
> out.println("</form></body></html>");
> }
> }
>
> Could anybody spare some time to help me.
> Thanks in advance
> Sanjeev
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
