Hi Everyone,
I am new to his forum. I am developing an asp page using Javascript. I am not able to solve a problem i.e., I ve 2 dropdown lists. Based on the 1st dropdown list's data, second dropdownlist has to be populated (retrieving data from database). Can anyone help me in sorting this issue. Im posting my code below...
<HTML>
<HEAD>
<script language="JavaScript">
var clockID = 0;
function UpdateClock()
{
if(clockID) {
clearTimeout(clockID);
clockID = 0;
}
var tDate = new Date();
document.theClock.theTime.value = ""
+ tDate.getHours() + ":"
+ tDate.getMinutes() + ":"
+ tDate.getSeconds();
clockID = setTimeout("UpdateClock()", 1000);
}
function StartClock()
{
clockID = setTimeout("UpdateClock()", 500);
}
function KillClock()
{
if(clockID) {
clearTimeout(clockID);
clockID = 0;
}
}
function checkform()
{
if (document.form1.mlfrom.value=='')
{
alert('Please enter the name');
document.form1.mlfrom.focus();
return false;
}
else if (document.form1.cont.value=='')
{
alert('Please enter the Contact No / Extension');
document.form1.cont.focus();
return false;
}
else if (document.form1.comdesc.value=='')
{
alert('Please enter the complaint description');
document.form1.comdesc.focus();
return false;
}
return true;
}
function hidefield()
{
if(document.form1.location.selectedIndex == 0 )
{
document.form1.astno.disabled = true;
document.getElementById("A").style.display='block' ;
}
else if(document.form1.location.selectedIndex == 1 )
{
document.form1.astno.disabled = false;
document.getElementById("A").style.display='true';
}
}
function assests()
{
What code can i write here ? How can I connect to database within this function ? What is the right method ? Please guide me with alternate way if any ?
}
</script>
<TITLE>Company Name</TITLE></HEAD>
<BODY bgcolor=silver onload="StartClock()" onunload="KillClock()">
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.open "filedsn=C:\proj\Maintenance\mnd"
set rs2 = Server.CreateObject("ADODB.recordset")
sq = "Select * from division"
rs2.Open sq,conn
%>
<form name="theClock"><input type=text name="theTime" size=8></form>
<center><H1>Company Name</H1></center>
<center><H3>Complaint Register</H3></center>
<table align=center border=0>
<tr>
<td>From</td>
<td><form action="Regicomp.asp" method="post" id=form1 name=form1 onsubmit="return checkform();">
<input name=mlfrom></td>
</tr>
<tr>
<td>Nature of Complaint</td>
<td>
<select name="location" onchange="hidefield()">
<option selected>Non Production
<option>Production
</select>
</td>
</tr>
<tr>
<td>Division</td>
<td><select name="div" onchange="assests()">
<% Do while not rs2.EOF %>
<option><%Response.Write(rs2.Fields (1)) %></option>
<% rs2.MoveNext
Loop %>
</select>
</td>
<tr id="A">
<td>Asset Number</td>
<td><select name="astno">
<option> </option>
</select>
</td>
</tr>
<tr>
<td>Complaint Description</td>
<td><textarea name=comdesc rows=8 cols=40></textarea></td>
</tr>
<tr>
<td><input type = submit value="Register Complaint" name=regis></td>
<td><input type = reset value="Clear" name=cls></td>
</tr>
</form>
</table>
</BODY>
</HTML>
Populating Dropdown list based on the other dropdownlist 
Linear Mode
