JSP: How to Extract values from dropdown

•

What is DaniWeb IT Discussion Community?

You're currently browsing the JSP section within the Web Development category of DaniWeb, a massive community of 392,071 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,217 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our JSP advertiser: Lunarpages JSP Web Hosting

Thread Tools Display Modes

Views: 10012 | Replies: 1

•

Join Date: Jun 2006

Posts: 1

Reputation: jeff_00789 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

jeff_00789 jeff_00789 is offline

Offline

Newbie Poster

JSP: How to Extract values from dropdown

Jun 30th, 2006

Hi, i want to know how to extract values from drop down box for processing in next field. In my file first drop down has list of countries taken from a database. I want to show location of that particular country in the other dropdown. The list of all locations is also in the same database. My code is as follows.

Help with Code Tags

(Toggle Plain Text)

<html><body><form name="frm" method="post" action="update.jsp">


<b>COUNTRY:</b>&nbsp;</td>
<select name="coun" style="width: 246px" onChange ="this.frm2.submit();"  ><option value="">Select</option>
		<% 
			 sql = dbconn.prepareStatement("select * from T500L order by LTEXT ");
					results = sql.executeQuery();
					while(results.next()){
					String name = results.getString(2);
					String id   = results.getString(1);
					
		%><option value="<%= name %>">
		<% out.println(name); %>
		
		</option>
		<%} results.close(); sql.close(); %>
		</select>						
		
                  <b>LOCATION:</b>&nbsp;</td>
                <select name="loc" style="width: 246px"><option value="">Select</option></select>


</form>
</body>
</html>

could anyone please give me a solution.

•

Join Date: Sep 2006

Posts: 6

Reputation: markenranosa is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

markenranosa markenranosa is offline

Offline

Newbie Poster

Re: JSP: How to Extract values from dropdown

Sep 21st, 2006

i have a suggestion create an arraylist,.. upon retrieving the values for the first dropown, store your needed values in the arraylistso that when you close the connection you can use arraylist in any possible ways that you want. Hope this helps.

Ken-Ken