ajax+options is null or not an Object

HI i have developed a simple ajax application contains two drop down lists and and one search button when i seleted a mangername from the popuated dropdwon list its dispalyed all the employee names on selection of the employee name and i kept search it should dispalay me the employee details when i click on search button its saying options is null or not an Obejct..

here im sending my code

select.jsp

<%@page import="java.sql.*"%>
 <html>
      <head>  
      <script language="javascript" type="text/javascript">  
      var xmlHttp  
      var xmlHttp
      function showEmp(str){
      if (typeof XMLHttpRequest != "undefined"){
      xmlHttp= new XMLHttpRequest();
      }
      else if (window.ActiveXObject){
      xmlHttp= new ActiveXObject("Microsoft.XMLHTTP");
      }
      if (xmlHttp==null){
      alert("Browser does not support XMLHTTP Request")
      return;
      } 
      var url="getemp.jsp";
      url +="?managername="+str;
      alert(url);
      xmlHttp.onreadystatechange = stateChange;
      xmlHttp.open("GET", url, true);
      xmlHttp.send(null);
      }

      function stateChange(){   
      if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){   
      document.getElementById("empname").innerHTML=xmlHttp.responseText

      }   
      }


      function searchDetails(){
          var combo = document.getElementsByName("empname");
         //alert(combo.options[combo.selectedIndex].text);
          var str = combo.options[combo.selectedIndex].value;

          alert("val of str is "+str);
          if (typeof XMLHttpRequest != "undefined"){
              xmlHttp= new XMLHttpRequest();
              }
              else if (window.ActiveXObject){
              xmlHttp= new ActiveXObject("Microsoft.XMLHTTP");
              }
              if (xmlHttp==null){
              alert("Browser does not support XMLHTTP Request")
              return;

              } 

          var url="check.jsp";
          url +="?count="+str;
          alert(str);
          xmlHttp.onreadystatechange = stateChange1;
          xmlHttp.open("GET", url, true);
          xmlHttp.send(null);
          }

          function stateChange1(){   
          if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){
           document.getElementById("data").innerHTML=xmlHttp.responseText


                          }   
          }

      </script>  
      </head>  
      <body>  
      Select ManagerName:<select name='managername' onchange="showEmp(this.value)">  
       <option value="none">SelectManagername</option>  

    <%
 Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();  
 Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","hr","hr");  
 Statement stmt = con.createStatement();  
 ResultSet rs = stmt.executeQuery("Select * from employee_table1");
 while(rs.next()){
     %>
      <option value="<%=rs.getString(3)%>"><%=rs.getString(3)%></option>  
      <%
 }
     %>
      </select>  

      <br>  
      <div id='empname'>  
      <select name='empname' >  
      <option value='-1'></option>  
      </select> 
           </div>  
       <input  type='button'   value= 'SearchforempDetails' onclick='searchDetails();' >
           <div id='data'>  
      <table name='data' >  
      </table>  
      </div>
      </body>
      </html>

getemp.jsp

<%@page import="java.sql.*"%>
<%
String managername=request.getParameter("managername");  
 String buffer="<select name='empname'><option value='-1'>SelectEmployeeName</option>";  
 try{
 Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();  
 Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","hr","hr");  
 Statement stmt = con.createStatement();  
 ResultSet rs = stmt.executeQuery("Select * from employee_table1 where managername='"+managername+"' ");  
   while(rs.next()){
   buffer=buffer+"<option value='"+rs.getString(2)+"'>"+rs.getString(2)+"</option>";  
   }  
 buffer=buffer+"</select>";  
 response.getWriter().println(buffer); 
 }
 catch(Exception e){
     System.out.println(e);
 }

 %>

check.jsp

<%@page import="java.sql.*"%>
<%
String empname=request.getParameter("count");  
 String buffer="<table name='data'>";  
 try{
 Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();  
 Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","hr","hr");  
 Statement stmt = con.createStatement();  
 ResultSet rs = stmt.executeQuery("Select * from employee_table1 where empname='"+empname+"' ");  
   while(rs.next()){
   buffer=buffer+"<tr><td>"+rs.getString("empcode")+"</td><td>"+rs.getString("org")+"</td></tr>";  
 }  
 buffer=buffer+"</table>";  
 response.getWriter().println(buffer); 
 }
 catch(Exception e){
     System.out.println(e);
 }
  %>
   <%=empname%>

Database table table name employee_table1;

and empcode, empname, managername, org are columns

Pls help me

Thanks in Adavace

View Answers

November 2, 2011 at 4:03 PM

Please visit the following links:

http://www.roseindia.net/answers/viewqa/JSP-Servlet/14516-By-dropdownlist-retrive-data-from-database--and-show-in-textbox-in-jsp..html

http://www.roseindia.net/jsp/comboSelect.shtml

November 4, 2011 at 12:03 PM

hi Thanks,

I figured out the solution