populating textarea from dropdown box selection

[dale conn]

Hi all

I have a drop-down list which is populated dynamically from a database table

I'm trying to populate a textarea when a selection is made from a drop-down box on the same page

Is anyone able to show mw how to do this?

My code for the drop-down box

    
<select name="list" id="list">                              
<%
      try
      {
      sql = "select * from table";
      
      conn = getConnection();
        stmt = conn.createStatement();
        rs = stmt.executeQuery(sql); 
                                                
      while (rs.next())
      {                        
            Id = rs.getString("id");
            name = rs.getString("name");
                                                                              
            %>
            <option value="<%=Id%>"><%=name%></option>
            <%
      }      
                                                      
      rs.close();
      }
      catch (Exception e)
      {      
            ....error
      }
      finally
      {
            ....close
      }                                                            
%>
</select>

What i then want to do is take the 'id' value (from the selection made from the drop-down box) and pass this to another sql query e.g. select * from table1 where id = <%=id%>, so i can get the contents and populate the textarea which is on the same page as the drop-down box

any help much appreciated

[Bear Bibeault]

You have a grave misconception regarding how JSP works. All that code that you have in the JSP is executing on the server long before the page is sent to the browser. So it is impossible for it to react to on-page events such as dropdown selections.

Perhaps this article will shed some light on what really goes on during the life-cycle of a JSP.

After reading it, you should understand why the approach you propose can never work, and that you need to use Javascript, perhaps with the help of some Ajax, in order to accomplish what you are trying to do.
[ April 02, 2007: Message edited by: Bear Bibeault ]

[dale conn]

Got this working now

Thanks