这个问题怎么解决!
SQL数据库
库名:bii
表名:bigclass
我加了一个键为biguser
以前程序是列出bigclassname键的所有东西我的意思是想加一个BIGUSER
列出的下拉条里BIGUSER值为1的例!
<%PageName="user_NewsAdd"%>
<!--#include file="../admin/session.asp"-->
<!--#include file="../const.asp"-->
<table border="1" width="760" cellspacing="0" cellpadding="1" bgcolor="<%=MainBgColor%>">
<tr>
<td valign=top>
<form method="POST" action="user_NewsAdd2.asp">
<table border="1" width="100%" cellspacing="0" cellpadding="1" class="TableLine" bordercolorlight="<%=MainBColor%>" bgcolor="<%=MainCColor%>">
<tr>
<td width="100%" height="20" colspan=2 align=center bgcolor="<%=MainTColor%>"><b>增 加 新 闻</b></td>
</tr>
<tr>
<td align="center">
<p> </p>
<p> </p>
<p>
<%
adminURL="user_NewsAdd1.asp?"
sql=" select * from BigClass order by BigClassID"
rs.Open sql,conn,1,1
%>
<select name="BigClassName" size="1" onChange="window.open('<%=adminURL%>BigClassName='+this.options[this.selectedIndex].value,'_self')">
<option value="" <%if request("BigClassName")="" then%> selected<%end if%>>选择大类</option>
<%
while not rs.EOF
%>
<option<%if request("BigClassName")=rs("BigClassName") and request("BigClassName")<>"" then%> selected<%end if%>
value="<%=rs("BigClassName")%>" name=BigClassName><%=rs("BigClassName")%></option>
<%
rs.MoveNext
wend
%>
</select>
<%
if request("BigClassName")<>"" then%>
<select name="SmallclassName" size="1">
<option value="" <%if request("SmallclassName")="" then%> selected<%end if%>>选择小类</option>
<%
set Trs=server.createobject("adodb.recordset")
sql="select * from SmallClass where BigClassName='"&request("BigClassName")&"' order by SmallClassID"
Trs.open sql,conn,1,1
Do while not Trs.eof
%>
<option<%if request("SmallclassName")=Trs("SmallclassName") and request("SmallclassName")<>"" then%> selected<%end if%> value="<%=Trs("SmallclassName")%>" name=SmallclassName><%=Trs("smallclassname")%></option>
<%
Trs.MoveNext
Loop
Trs.close
%>
<%else%>
<select name="SmallclassName" size="1">
<option value="" selected>选择小类</option>
<%end if%>
</select>
</p>
<p> </p>
<p> </p>
</td>
</tr>
<tr>
<td align="center" height="25">
<%if request("BigClassName")="" then%>
<input type="button" value=" 确 定 " name="cmdok" onclick="window.alert('请选择大类!')">
<%else%>
<input type="submit" value=" 确 定 " name="cmdok">
<%end if%>
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<%rs.close
set Trs=nothing
set rs=nothing
htmlend(1)
%>