Combobox value returns "Null"

rajaramesh · 03-16-2009, 07:40 AM

Hi friends,

I want to display a field value in combo box from database.
But the result, it returns me null in combo box, even in textbox also..

Plz help me in this regard.
Advance thanks to u all.

Code:

<%@ page import="java.sql.*" %>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>
<HTML>
    <HEAD>
        <TITLE>Database</TITLE>
    </HEAD>

    <BODY>
        <H1>Database</H1>
        <% 
            Connection connection = DriverManager.getConnection("jdbc:odbc:emaildb", "", "");
            Statement statement = connection.createStatement();
            String Cname = request.getParameter("CompName");
             String Fy = request.getParameter("FYear");
              String Qtr = request.getParameter("Quarter");
               String QtrAm = request.getParameter("QtrAmt");  
          ResultSet resultset = statement.executeQuery("select CompanyName, sum(ForQtr)as Tota from Imports group by CompanyName") ;
                 
          
            if(!resultset.next()) {
            out.println("Sorry, could not find that CompInfo. ");
            } else {
        %>
        	<TABLE BORDER="1">
            <TR>
              
           <!--<TH>Financial Year</TH>
           <TH>Sum of Quarters</TH>-->
           </TR>
            <% String AB=request.getParameter("CompanyName");%>
     		<input type="text" value="<%=AB%>">   
           
           <select>
           <%
           while(resultset.next()) {
           String ABC=request.getParameter("CompanyName");
            out.print("<option>"+ABC+"</option>");
           
           %>
           </select>
           <TR>
               <TD> <%= resultset.getString(1) %> </TD>
               <TD> <%= resultset.getString(2) %> </TD>
              
          </TR>
      
       <%}%>
                    
       </TABLE>
          
       
       <BR>
      
           
       <% 
           } 
       %>
    </BODY>
</HTML>

regards
raja

shyam · 03-20-2009, 06:31 PM

you need to name ur form elements otherwise how can the application server distinguish one textbox from another? same goes for the selects too...