1:首先是表单中的下拉列表:
<form name="jiaoshi" >
<%
sql = "select * from room"
set rs = server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
<select name="jiaoshi" >
<option value="" selected>请选择</option>
<%
do while not rs.eof
%>
<option value="<%=trim(rs("ro_name"))%>"><%=rs("ro_name")%></option>
<%
i=i+1
rs.movenext
loop
rs.close
set rs = nothing
%> </select>
</form>
2:是下拉列表的onchange事件:
<SCRIPT LANGUAGE="VBScript">
<!--
sub zhouci_onchange
if xueqi.xueqi.value = "" Or jiaoshi.jiaoshi.value = "" Then
MsgBox "不能为空选项,请选择学期.教室和周次!", vbOKOnly, "信息提示"
zhouci.zhouzi.value=""
exit sub
else
wkn=1
Do While wkn <=35
strwkn=trim((wkn-1)+1)
select case wkn
case 1
<%
sqltxt = "select * from yyxx where ro_name='"&request("document.jiaoshi.jiaoshi.options.value")&"' and we_name='第一周' and weekday_name=1 and jie_ci=12"
set rs1 = server.createobject("adodb.recordset")
rs1.open sqltxt,conn,1,1
if rs1.recordcount<>0 then
%>
msgbox "<%=trim(rs1("js_name"))%>,"&document.jiaoshi.jiaoshi.options.value&""
document.form1.button1.value="<%=trim(rs1("js_name"))%>"
document.form1.button1.disabled=true
<%else%>
document.form1.button1.value="待定"
<%end if%>
end select
问题:
为什么ro_name='"&request("document.jiaoshi.jiaoshi.options.value")&"'取不到值啊
请高手们指教....
