28,391
社区成员
发帖
与我相关
我的任务
分享
<form method="post" action="nowkqinfo.asp" name="deptform" id="deptform" >
职务:
<%
'读取部门职务
set conn=opendb("oabusy","conn","accessdsn")
set rs8=server.createobject("adodb.recordset")
sql8="select DISTINCT userlevel from userinf"
rs8.open sql8,conn,1
%>
<select size=1 name="userlevel">
<%
if not rs8.eof and not rs8.bof then
userlevel=rs8("userlevel")
end if
if request("userlevel")<>"" then
userlevel=request("userlevel")
end if
while not rs8.eof and not rs8.bof
%>
<option value="1">全部</option>
<option value="<%=rs8("userlevel")%>"<%=selected(userlevel,rs8("userlevel"))%>><%=rs8("userlevel")%></option>
<%
rs8.movenext
wend
conn.close
set conn=nothing
set rs8=nothing
%>
</select>
<input type="submit" value="查看"><input type="button" name="pintbtn" value="打印" onClick="printsub();">
</form>
<%@ Page aspcompat=true %>
<form method="get" action="nowkqinfo.asp" name="deptform" id="deptform" >
职务:
<%
'读取部门职务
'set conn=opendb("oabusy","conn","accessdsn")
'set rs8=server.createobject("adodb.recordset")
'sql8="select DISTINCT userlevel from userinf"
'rs8.open sql8,conn,1
%>
<select size=1 name="userlevel">
<option value="1">全部</option>
<option value="2"><%=2%></option>
<option value="3"><%=3%></option>
</select>
<input type="submit" value="查看"><input type="button" name="pintbtn" value="打印" onClick="printsub();">
</form>
<script>
function printsub(){
alert(document.deptform.userlevel.value);
}
</script>
<form method="post" action="nowkqinfo.asp" name="deptform" id="deptform" >
<select name="userdept">
<option value=值1>1</option>
<option value=值2>2</option>
<option value=值3>3</option>
</select>
<select name="userlevel">
<option value=值1>1</option>
<option value=值2>2</option>
<option value=值3>3</option>
</select>
<input type="submit" value="查看">
</form>
在下面我要获取userlevel这个下拉菜单的值 该怎么写
userlevel=request.form("userlevel") ???
'如果rs8("userlevel")是文本
if userlevel=rs8("userlevel") then sel=" selected" else sel=""
'如果rs8("userlevel")是数字
''''''''''if userlevel=rscintrs(rs8("userlevel")) then sel=" selected" else sel=""
<form method="post" action="nowkqinfo.asp" name="deptform" id="deptform" >
职务:
<%
'读取部门职务
userlevel=requeest.form("userlevel")
if userlevel="" then userlevel=1
set conn=opendb("oabusy","conn","accessdsn")
set rs8=server.createobject("adodb.recordset")
if userlevel=1 then
sql8="select DISTINCT userlevel from userinf"
else
sql8="另一个SQL语句"
end if
rs8.open sql8,conn,1,1
%>
<select size=1 name="userlevel" onchange="document.deptform.submit();">
<%
do while not rs8.eof
'如果rs8("userlevel")是文本
if userlevel=rs8("userlevel") then sel=" selected" else sel=""
'如果rs8("userlevel")是数字
if userlevel=rscintrs(rs8("userlevel")) then sel=" selected" else sel=""
%>
<option value="1" selected>全部</option>
<option value="<%=rs8("userlevel")%>"<%=sel%>><%=rs8("userlevel")%></option>
<%
rs8.movenext
loop
if rs.state<>0 then rs.close
set rs8=nothing
conn.close: set conn=nothing
%>
</select>
<input type="submit" value="查看"><input type="button" name="pintbtn" value="打印" onClick="printsub();">
</form>