UC知道2级下拉列表选择后再显示表中其他联动属性问题
来源：百度知道 编辑：UC知道 时间：2024/06/01 04:14:45
数据库2个表,表名和属性值如下
CourseN: C_ID C_Name
Course: CourseID CourseName CourseTime CoursePlace CourseLeft
-------------------------------
代码如下,想在2级列表中选择CourseName和CourseTime后显示Course表中所关联的CoursePlace 和CourseLeft的值,求具体实现方法,谁能帮下忙,谢谢了
代码如下
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../Connections/ConSelCourse.asp" -->
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_ConSelCourse_STRING
Recordset1.Source = "SELECT * FROM CourseN"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
dim id
id=request.QueryString("id")
if id="1" then
response.Write "<br>" & request.Form("lstb"
CourseN: C_ID C_Name
Course: CourseID CourseName CourseTime CoursePlace CourseLeft
-------------------------------
代码如下,想在2级列表中选择CourseName和CourseTime后显示Course表中所关联的CoursePlace 和CourseLeft的值,求具体实现方法,谁能帮下忙,谢谢了
代码如下
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../Connections/ConSelCourse.asp" -->
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_ConSelCourse_STRING
Recordset1.Source = "SELECT * FROM CourseN"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
dim id
id=request.QueryString("id")
if id="1" then
response.Write "<br>" & request.Form("lstb"
剩余代码如下
<body>
<<form action="index.asp?id=1" method="post" name="frmdlist" id="frmdlist">
<table width="408" border="0" align="center" cellpadding="2" cellspacing="2">
<tr>
<td width="400" align="center"> </td>
</tr>
<tr>
<td align="center">选择实验名称
<%response.write "<select name=""lstb"" style=""width:200"" onChange=""sdbSortChange(this,frmdlist.lsts);"">" & pstr & "</select>"%></td>
</tr>
<tr>
<td align="center"> </td>
</tr>
<tr>
<td align="center">选择实验时间
<select style="width:200" name="lsts" id="lsts">
</select></td&g