dim groupid
dim province
groupid=request("groupid")
province=request("province")
set rs=server.createobject("adodb.recordset")
conn = "DBQ=" + server.mappath("member.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
if request("groupid")<>"" then
sql="select * from member where groupid like'%" & groupid & "%'"
elseif request("province")<>"" then
sql="select * from member where province like'%" & province & "%'"
else
sql="select * from member"
end if
该为:
dim groupid
dim province
groupid=request("groupid")
province=request("province")
set rs=server.createobject("adodb.recordset")
conn = "DBQ=" + server.mappath("global.asa") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
if request("groupid")<>"" then
sql="select * from member where groupid like'%" & groupid & "%'"
elseif request("province")<>"" then
sql="select * from member where province like'%" & province & "%'"
else
sql="select * from member"
end if