Programming Error

Domain Table:--

Rfcdkey DomainName DomainValue DepDomainValue Statcd
1 StateCd Maharashtra Mumbai A
2 StateCd Maharashtra Pune A
3 StateCd Maharashtra Nashik A
4 StateCd Karnataka Bangalore A
5 StateCd Delhi Delhi A
6 StateCd West Bengal Kolkata A
7 StateCd West Bengal Dargeeling A
8 Category Matrimonial Bride A
9 Category Matrimonial Groom A

PlaceAd.jsp:--code

<%@page import="java.sql.*"%>
<%@page import="java.io.*"%>

<%
Connection con=null;
Statement stmt=null;
//String st;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:Advdsn");
stmt=con.createStatement();
}
catch(SQLException se){
out.println("Database Error:"+se.getMessage());
}
catch(Exception e){
e.toString();
}
%>
<html>
<head>
<script language="JavaScript">
function Draft(text1,text2){
var v1=text1.value;
var v = 0;
v2=v1.replace(/\s/g,' ');
v2=v2.split(' ');
for (i=0; i<v2.length; i++) {if (v2[i].length > 0) v++;}
text2.value=v;
}
function checkPhoneNo(num){
if(isNaN(num)){alert("Invalid Phone Number. The only characters permitted are 0 to 9"); return 0;}
else{return 1;}
}
function Validate()
{
var phone=document.form.PhoneNo;
var email=document.form.Email;
if(email.value=="")
{ alert("Please enter valid Email Id");
return false;
}
apos=email.value.indexOf("@")
dotpos=email.value.lastIndexOf(".")
if (apos<1 || dotpos-apos<2)
{
alert("Invalid Email Id")
email.value=="";
email.focus();
return false;
}

if((phone.value=="")||(phone.value==null))
{ alert("Please enter valid PhoneNo");phone.focus();
return false;
}
if (checkPhoneNo(phone.value)==false){
phone.value="";
phone.focus();
return false;
}
if ((phone.value.length==8)||(phone.value.length==10)){
return true;
}
else{
alert("Phone Number must be of 8 numbers or 10 numbers");
return false;
}
return true;
}

</script>
</head>

<body bgcolor="lightblue">
<marquee behavior="alternate" scrollamount=5 scrolldelay=10><h1><font size=4 face="Stroustroup" color="#993355">Advertisement Management System</h1></font></marquee><br>
<p align=center><b> <font color="669933" size=4>Create Ad </font></b></p><br>
<% String no=request.getParameter("OrderNo");
out.println("The Placing of Ad is of Order Number "+no+"<br>"); %>
<form name="form" method="post" action="Preview.jsp" onsubmit="return Validate();">
<table>
<tr><td>State:</td><td> <select name="State" size=1>
<%
ResultSet state=stmt.executeQuery("SELECT distinct DomainValue FROM Domain WHERE DomainName = 'StateCd' Order by 1");
while(state.next())
{
String st=state.getString("DomainValue");
%>
<option value="<%=st %>">
<%

out.println(st); %>
</option>
<%}%>
</select></td></tr>
<tr><td>City:</td><td> <select name="City" size=1>
<%
ResultSet city=stmt.executeQuery("Select DepDomainValue from Domain where DomainName='StateCd' and DomainValue=(SELECT distinct DomainValue FROM Domain WHERE DomainName = 'StateCd') ");
while(city.next())
{
String ci=city.getString("DepDomainValue");
%>
<option value="<%=ci %>">
<%

out.println(ci); %>
</option>
<%}%>
</select></td></tr>
<tr><td>Main Category: </td><td><select name="mainCat" size=1>
<%
ResultSet mainC=stmt.executeQuery("SELECT distinct DomainValue FROM Domain WHERE DomainName = 'Category' Order by 1 ");
while(mainC.next())
{
String mc=mainC.getString("DomainValue");
%>
<option value="<%=mc %>">
<%

out.println(mc); %>
</option>
<%}%>
</select></td></tr>

<tr><td>Sub Category:</td><td><select name="subCat" size=1>
<%
ResultSet subC=stmt.executeQuery("Select DepDomainValue from Domain where DomainName='Category' and UCase(DomainValue)=ucase('Matrimonial') Order by 1");
while(subC.next())
{
String sc=subC.getString("DepDomainValue");
%>
<option value="<%=sc %>">
<%

out.println(sc); %>
</option>
<%}%>

</select></td></tr>
<tr><td>Title:</td><td> <input type=text name="Title" size=25 ></td></tr>
<tr><td>Draft Your Ad here:</td><td><textarea name="DraftAd" cols="15" rows="2" onkeyup="Draft(this,document.form.Count)"></textarea></td></tr>
<tr><td>No of words:</td><td><input name="Count" type="text" value="0" onkeyup="Draft(document.form.DraftAd,this)" readonly></td></tr>
<tr><td>Image:</td><td><input type="file" name="img"></td></tr>
<tr><td>Email:</td><td><input type=text name="Email" size=25></td></tr>
<tr><td>Phone No:</td><td><input type=text name="PhoneNo" size=25 maxlength=10></td></tr>
<tr><td>Select Newspaper:</td><td><select name="NewsPaper" size=1>
<%
ResultSet news=stmt.executeQuery("SELECT distinct DomainValue FROM Domain WHERE DomainName = 'Newsp' Order by 1");
while(news.next())
{
String np=news.getString("DomainValue");
%>
<option value="<%=np %>">
<%

out.println(np); %>
</option>
<%}%>
</select></td></tr>
<br>
<tr><td>Select Your Date:</td><td><select name="day" size=1>

<%for (int date=1;date<=31;date++)
{
%>
<option value="<%=date%>"><%=date%></option>
<%}%>
</select></td></tr>
<tr><td>Month:</td><td><select name="Month" size=1>
<%
for (int month=1;month<=12;month++){
%>
<option value="<%=month%>"><%=month%></option>
<%}%>
</select></td></tr>
<tr><td>Year:</td><td><select name="Year" size=1>
<%
for (int year=2010;year<=2050;year++){
%>
<option value="<%=year%>"><%=year%></option>
<%}%>
</select></td></tr>
<tr><td>Select Number of Days:</td><td><input type=text name="numDays" size=5></td></tr>
<tr><td><input type="submit" name="submit" value="Preview"></td></tr>
</form>
</body>
</html>

Above This is the Domain Table created in access.
I loaded all values from Domain table in PlaceAd.jsp
but i want that if user selects Maharashtra then only city related to that state must be visible in city combo box.
Eg: if Maharashtra is selected then only mumbai,pune and nashik must be visible in city combo box ??
Please Reply me Sir how to do this actually i tried but its giving me error??
So Please Reply me.
Thank You Sir.

View Answers