Hi,
I have a ASP page which has a form with some dynamic list boxes generated from a database. What I would like to do is to write some asp code that will generate dynamically generate another list box after the user has made a selection from a previous one. Here is the code.
<%
Dim strConnect
Dim objRS ' Declare variable for recordset object
Set objRS = Server.CreateObject("ADODB.Recordset"
'Create the the recordset object
objRS.open "Room", strConnect
objRS.MoveFirst
%>
<HTML>
<HEAD>
<TITLE>MHCHS - Report a fault</TITLE>
</HEAD>
<BODY BGCOLOR="#FFFF80">
<%
Response.write "<A HREF=home.asp>Log out</A><BR>"
End If
%>
<FORM ACTION = "ProcessAddFault.asp" METHOD = "POST">
<P ALIGN="CENTER"><b>Fault Reported by :<% =session("StaffName" %></B><BR></B>
<P ALIGN="CENTER"><b>Email Address:<% =session("EmailAddress" %></B><BR></B>
<P ALIGN="CENTER"><b>Type Of Fault </b><SELECT NAME ="FaultType" Size="1">
<OPTION SELECTED VALUE="Hardware">Hardware</OPTION>
<OPTION VALUE="Software">Software</OPTION>
<OPTION VALUE="Network">Network</OPTION>
<OPTION VALUE="Other">Other</OPTION>
'Code used and adapted from Beginning ASP Databases on page 162
</SELECT><p align="CENTER"><b>Location </b>
<SELECT NAME="Location" SIZE="1">
<%
Do While NOt objRS.EOF
Response.Write "<OPTION VALUE='" & objRS("RoomNo" & "'>" & "<BR>"
Response.Write objRS("RoomNo" & "</OPTION>" & "<BR>"
objRS.MoveNext
Loop
objRS.Close
Set objRS = Nothing
%>
</SELECT></B><BR>
' After the user has selected the room number I would like to show another drop down list box which shows all the serial nos of computers stored in that room. Does asp allow this or do i require some javascript?
<P ALIGN="CENTER"><TextArea Name = "Details" COLS=50 ROWS= 10></TextArea><BR><BR>
<input type = "Submit" Value = "Submit Fault"></a><input type = "Reset" Value = "Clear Form"><BR>
<BR>
If anyone has any ideas could they please let me know
</BODY>
</HTML>
I have a ASP page which has a form with some dynamic list boxes generated from a database. What I would like to do is to write some asp code that will generate dynamically generate another list box after the user has made a selection from a previous one. Here is the code.
<%
Dim strConnect
Dim objRS ' Declare variable for recordset object
Set objRS = Server.CreateObject("ADODB.Recordset"
'Create the the recordset objectobjRS.open "Room", strConnect
objRS.MoveFirst
%>
<HTML>
<HEAD>
<TITLE>MHCHS - Report a fault</TITLE>
</HEAD>
<BODY BGCOLOR="#FFFF80">
<%
Response.write "<A HREF=home.asp>Log out</A><BR>"
End If
%>
<FORM ACTION = "ProcessAddFault.asp" METHOD = "POST">
<P ALIGN="CENTER"><b>Fault Reported by :<% =session("StaffName"
%></B><BR></B><P ALIGN="CENTER"><b>Email Address:<% =session("EmailAddress"
%></B><BR></B><P ALIGN="CENTER"><b>Type Of Fault </b><SELECT NAME ="FaultType" Size="1">
<OPTION SELECTED VALUE="Hardware">Hardware</OPTION>
<OPTION VALUE="Software">Software</OPTION>
<OPTION VALUE="Network">Network</OPTION>
<OPTION VALUE="Other">Other</OPTION>
'Code used and adapted from Beginning ASP Databases on page 162
</SELECT><p align="CENTER"><b>Location </b>
<SELECT NAME="Location" SIZE="1">
<%
Do While NOt objRS.EOF
Response.Write "<OPTION VALUE='" & objRS("RoomNo"
& "'>" & "<BR>"Response.Write objRS("RoomNo"
& "</OPTION>" & "<BR>"objRS.MoveNext
Loop
objRS.Close
Set objRS = Nothing
%>
</SELECT></B><BR>
' After the user has selected the room number I would like to show another drop down list box which shows all the serial nos of computers stored in that room. Does asp allow this or do i require some javascript?
<P ALIGN="CENTER"><TextArea Name = "Details" COLS=50 ROWS= 10></TextArea><BR><BR>
<input type = "Submit" Value = "Submit Fault"></a><input type = "Reset" Value = "Clear Form"><BR>
<BR>
If anyone has any ideas could they please let me know
</BODY>
</HTML>
