It appears that you are using cmbzone in the servlet before it is used in the
form so the 'req.getParameter("cmbzone")' returns null.
You may also have a problem later because cmbzone is used for the name of two
different HTML select objects.
Tim Gallagher
sanjeev kumar wrote:
> 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);
>
> //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>");
> //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
