Plus, you only seem to be requesting one value from the database, so asking
for the second is going to give you an IndexArrayOutOfBoundException.
(*Chris*)
----- Original Message -----
From: Antonio Villafana <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 04, 1999 6:05 AM
Subject: Re: urgent help reqd for IndexArrayOutOfBoundException
> 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
>
___________________________________________________________________________
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
