JSTL tags

[SP Nam]

Hi

1.I have a jsp page which uses jstl sql tags.
2.I have 3 column table id, name, city. id will be drop down and name, city are text boxes.
3.When I load the page all ids will be shown as drop down based on select query.
4.When I select one value from id drop down, the text boxes for name and city should show corresponding values for the id selected.
5.After that user may change values of name and city.
6.After all processing when user hit submit button, the data modified in text boxes should be updated to the table.

Here is the code for my jsp page:

<form method=post action="Edit.jsp">
 
<sql:transaction dataSource="${example}">
 
<sql:query var="Power">
SELECT ID FROM COMPANY WHERE id LIKE 'P^_%' ESCAPE '^'
</sql:query>
 
</sql:transaction>
<center>
<h4><p>Select ID:           
<select Name = "IdDrop">
 <c:forEach var="row" items="${Power.rows}">
        <option size="20"><c :-o	 ut value="${row.id}"/></option>
     </c:forEach>
</select>
 <p>
 </h4>
 
 <h4><p>Name:
 <input type="text" name="txtexName" size="15" value="" >
 </h4>
 
 <h4><p>City:
 <input type="text" name="txCity" size="15" value="" >
 </h4>
 
 
<input type="submit" value="SUBMIT"/>  
 
<input type="reset" value="CANCEL"/>
 
<center>
</form>
 

  

The critical part of it is when I select a value from id drop down, it has show values for name and city in text boxes and values can be editable.

Give me some example links or give some code snippets.

Thanks in Advance

SP Nam

[Bear Bibeault]

The critical part of it is when I select a value from id drop down, it has show values for name and city in text boxes and values can be editable.

I do not know what you mean by this.