ASP 不同数据类型 查询问题

来源:百度知道 编辑:UC知道 时间:2024/06/10 19:19:28
<form name="form1" method="post" action="">
请选择查询条件:<select name="xuanze">
<option value="name" selected>名字
<option value="xuehao">学号
<option value="sex">性别
</select>
= <input type="text" name="tiaojian">
<input type="submit" name="submit" value="开始查询">
</form>
<%
if request.Form("submit")="开始查询" then
xuanze=request.form("xuanze")
tiaojian=request.Form("tiaojian")
set conn=server.CreateObject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.MapPath("kaoqin.mdb")
set rs=conn.execute("select * from name where "&xuanze&" like '"&tiaojian&"%'")
if rs.bof and rs.eof then
resp

楼主可以这样
Dim que
if xuanze="xuehao" then
que = xuanze&"="&tiaojian
else
que = xuanze&" like '"&tiaojian&"%'"
end if

set rs=conn.execute("select * from name where "&que &"")

那就xuanze=clng(xuanze)