下拉菜单里的选项有序号名称两项，文本框为要输入的关键字
下拉菜单代码如下：
<form id="form1" name="form1" method="post" onSubmit="return check()"action="search.asp?selecttype&checkword">
<label>
<select name="selecttype">
<option value="all">全部内容</option>
<option value="xuhao">序号</option>
<option value="pname">项目名称</option>
<option value="spid">审批文号</option>
</select>
</label>
<label>
<input type="text" name="checkword" />
</label>
<label>
<input type="submit" name="Submit" value="查询" />
</label>
</form>
在search.asp页面的判断条件和sql语句该怎么写？请高手指教，谢谢

[CODE]selecttype=request.form("selecttype")
checkword=request.form("checkword")

select case selecttype
case "all"
sql="select * from table"
case "xuhao"
sql="select * from table where xuhao like '%"& checkword &"%'"
case "pname"
sql="select * from table where pname like '%"& checkword &"%'"
case "spid"
sql="select * from table where spid like '%"& checkword &"'%"
end select

conn.execute sql[/CODE]

function check()
{
//将这段代码加到check函数的最后一个return之前
var seltype=document.form1.selecttype.options[document.form1.selecttype.selectedIndex].value;
var chkword=document.form1.checkword.value;
document.form1.action="search.asp?selecttype="+seltype+"&checkword="+chkword;
}
<form id="form1" name="form1" method="post" onSubmit="return check()"action="search.asp?selecttype&checkword">
<label>
<select name="selecttype">
<option value="all">全部内容</option>
<option value="xuhao">序号</option>
<option value="pname">项目名称</option>
<option value="spid">审批文号</option>
</select>
</label>
<label>
<input type="text" name="checkword" />
</label>
<label>
<input type="submit" name="Submit" value="查询" />
</label>
</form>

非常感谢楼上的两位兄弟