[求助]如何实现下拉菜单和文本框关联的搜索 - 编程论坛

#2

tianyu1232007-10-16 17:05

[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]

#3

yms1232007-10-16 17:21

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>

#4

hufengxu8882007-10-18 15:26

非常感谢楼上的两位兄弟