Ad:

JSP Discussion Thread
Unsolved
Views: 4650

Jan 19th, 2009

3 drop down list

Expand Post »

Any one got hints how to do this?
I got 3 drop down list initally all 3 contains 4 option A,B,C,D.
After selecting A from 1stdrop down list,the 2nd and 3rd drop down list are left with B,C,D.
After selecting C form 2nd drop down list,the 3rd drop down list is left with B and D.
Any help/hints would be appreciated.
Thanks

Similar Threads

Populating a Drop-down List in PHP
Passing a drop down list item's value in HTML and CSS
Populate One Drop Down List From Another in ASP.NET
php mysql drop down list in PHP
drop down list question. in ASP.NET

dreamer14

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

31 posts
since Sep 2008

Permalink

Jan 19th, 2009

Re: 3 drop down list

JSP Syntax (Toggle Plain Text)
<script language="javascript"> 
 
function mul1() 
{ 
    String a = document.getElementById("one").value; 
   // document.getElementById("second").setAttribute("value",a);
<%    String sql22 = "Select * from test where two!='"+a+"'";
Statement stmt22=con.createStatement();
ResultSet rs22= stmt22.executeQuery(sql22);
out.print("<select name=\"two\" id=\"two\" onChange=\"mul2();\">");
while (rs22.next())
{
String qwe=rs22.getString("two");
out.print("<option value="+qwe+">"+qwe+"</option>");
}
out.print("</select>");
%>
} 
</script> 
<body> 
<%
String sql2 = "Select * from test";
Statement stmt2=con.createStatement();
ResultSet rs2= stmt2.executeQuery(sql2);
out.print("<select name=\"one\" id=\"one\" onChange=\"mul1();\">");
while (rs2.next())
{
String qwe=rs2.getString("two");
out.print("<option value="+qwe+">"+qwe+"</option>");
}
out.print("</select>");
%>
<script language="javascript"> 
 
function mul1() 
{ 
    String a = document.getElementById("one").value; 
   // document.getElementById("second").setAttribute("value",a);
<%    String sql22 = "Select * from test where two!='"+a+"'";
Statement stmt22=con.createStatement();
ResultSet rs22= stmt22.executeQuery(sql22);
out.print("<select name=\"two\" id=\"two\" onChange=\"mul2();\">");
while (rs22.next())
{
String qwe=rs22.getString("two");
out.print("<option value="+qwe+">"+qwe+"</option>");
}
out.print("</select>");
%>
} 
</script> 
<body> 
<%
String sql2 = "Select * from test";
Statement stmt2=con.createStatement();
ResultSet rs2= stmt2.executeQuery(sql2);
out.print("<select name=\"one\" id=\"one\" onChange=\"mul1();\">");
while (rs2.next())
{
String qwe=rs2.getString("two");
out.print("<option value="+qwe+">"+qwe+"</option>");
}
out.print("</select>");
%>

THis is what i have tried so far doesnt work

dreamer14

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

31 posts
since Sep 2008

Permalink

Jan 19th, 2009

Re: 3 drop down list

I would do something like

JavaScript Syntax (Toggle Plain Text)
function onAclick()
{
var item=document.getElementById("A").value;
document.getelementById("B").remove(item);
document.getelementById("C").remove(item);
document.getelementById("D").remove(item);
}
function onAclick()
{
var item=document.getElementById("A").value;
document.getelementById("B").remove(item);
document.getelementById("C").remove(item);
document.getelementById("D").remove(item);
}

And similar in other dropdowns
Diseirra

Last edited by peter_budo; Jan 19th, 2009 at 6:30 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

Diseirra

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jan 2009

Permalink

Jan 19th, 2009

Re: 3 drop down list

JSP Syntax (Toggle Plain Text)
%@page import="java.util.*"%>
<%@page import="java.lang.*"%>
<%@page import="java.sql.*"%>
<%@page import="java.text.*"%>
<%@page import="java.util.Date"%>
<%@include file="DBConnect.jsp"%>
<%@page import="java.util.Date"%>
<html> 
<head> 
<title>Untitled Document</title>  
</head> 
<script language="javascript"> 
function mul() 
{ 
var B=document.getElementById("one").value;
 
document.getelementById("tree").remove(B);
//document.getelementById("C").remove(B);
//document.getelementById("D").remove(B);
} 
</script> 
<body> 
<%
	String sql2 = "Select * from test";
	Statement stmt2=con.createStatement();
	ResultSet rs2= stmt2.executeQuery(sql2);
	out.print("<select name=\"one\" id=\"one\" onChange=\"mul();\">");
	while (rs2.next())
	{
	String qwe=rs2.getString("two");
	out.print("<option value="+qwe+">"+qwe+"</option>");
	}
	out.print("</select>");
 
		String sql21 = "Select * from test";
		Statement stmt21=con.createStatement();
		ResultSet rs21= stmt21.executeQuery(sql21);
		out.print("<select name=\"one1\" id=\"tree\">");
		while (rs21.next())
		{
		String qwe=rs21.getString("two");
		out.print("<option value="+qwe+">"+qwe+"</option>");
		}
		out.print("</select>");
%>
</body> 
</html>
%@page import="java.util.*"%>
<%@page import="java.lang.*"%>
<%@page import="java.sql.*"%>
<%@page import="java.text.*"%>
<%@page import="java.util.Date"%>
<%@include file="DBConnect.jsp"%>
<%@page import="java.util.Date"%>
<html> 
<head> 
<title>Untitled Document</title>  
</head> 
<script language="javascript"> 
function mul() 
{ 
var B=document.getElementById("one").value;

document.getelementById("tree").remove(B);
//document.getelementById("C").remove(B);
//document.getelementById("D").remove(B);
} 
</script> 
<body> 
<%
	String sql2 = "Select * from test";
	Statement stmt2=con.createStatement();
	ResultSet rs2= stmt2.executeQuery(sql2);
	out.print("<select name=\"one\" id=\"one\" onChange=\"mul();\">");
	while (rs2.next())
	{
	String qwe=rs2.getString("two");
	out.print("<option value="+qwe+">"+qwe+"</option>");
	}
	out.print("</select>");

		String sql21 = "Select * from test";
		Statement stmt21=con.createStatement();
		ResultSet rs21= stmt21.executeQuery(sql21);
		out.print("<select name=\"one1\" id=\"tree\">");
		while (rs21.next())
		{
		String qwe=rs21.getString("two");
		out.print("<option value="+qwe+">"+qwe+"</option>");
		}
		out.print("</select>");
%>
</body> 
</html>

I get a error message that say Object doesnt support this property or method

dreamer14

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

31 posts
since Sep 2008

Permalink

Mar 17th, 2011

Re: 3 drop down list

i have this type of code like
User:<select>
<option>Faculty</option>
<option>Student</option>
</select>
now what i want when i am selected Faculty option then page will be redirect to Faculty.jsp page is it possible in jsp ...plz reply me ...

erdhaval

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Mar 2011

Permalink

Mar 17th, 2011

Re: 3 drop down list

Click to Expand / Collapse Quote originally posted by erdhaval ...

i have this type of code like
User:<select>
<option>Faculty</option>
<option>Student</option>
</select>
now what i want when i am selected Faculty option then page will be redirect to Faculty.jsp page is it possible in jsp ...plz reply me ...

Start a new thread and read about onclick events:

JSP Syntax (Toggle Plain Text)

<select onchange="">
..
</select>

JSP Syntax (Toggle Plain Text)

<select onclick="">
..
</select>

http://www.w3schools.com/default.asp

javaAddict

Sponsor

Featured Poster

Reputation Points: 1014

Solved Threads: 446

Nearly a Senior Poster

Offline

3,258 posts
since Dec 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in JSP Forum Timeline: JSP: Determining username

Next Thread in JSP Forum Timeline: Image Upload with text fiedd

DaniWeb Message

Cancel Changes

User Name
Password