DaniWeb Forum Index > Web Development > JSP

3 drop down list

Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Sep 2008

Posts: 21

Reputation: dreamer14 is an unknown quantity at this point

Solved Threads: 1

dreamer14

Offline

Newbie Poster

3 drop down list

Jan 19th, 2009

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

•

Join Date: Sep 2008

Posts: 21

Reputation: dreamer14 is an unknown quantity at this point

Solved Threads: 1

dreamer14

Offline

Newbie Poster

Re: 3 drop down list

Jan 19th, 2009

 Help with Code Tags 
 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

•

Join Date: Jan 2009

Posts: 1

Reputation: Diseirra is an unknown quantity at this point

Solved Threads: 0

Diseirra

Offline

Newbie Poster

Re: 3 drop down list

Jan 19th, 2009

I would do something like

 Help with Code Tags 
 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.

•

Join Date: Sep 2008

Posts: 21

Reputation: dreamer14 is an unknown quantity at this point

Solved Threads: 1

dreamer14

Offline

Newbie Poster

Re: 3 drop down list

Jan 19th, 2009

 Help with Code Tags 
 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