求助这段 ASP access 数据库 查询 代码问题

来源:百度知道 编辑:UC知道 时间:2024/05/28 03:22:52
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("../mdb/book.mdb")
set rs=server.createobject("adodb.recordset")
%>

<%
name=request.form("name")
atype=request.form("type")
publishing=request.form("publishing")

sql1=""
if name <>"" then
Sql1= Sql1 & "name like '%"&name&"%'"
end if
if atype <>"" then
Sql1= Sql1 & "or type like '%"&atype&"%'"
end if
if publishing <>"" then
Sql1= Sql1 & "or publishing like '%"&publishing&"%'"
end if
response.write sql1
sql="select * from booksx where sql1 "
rs.open sql,conn,1,1

<%
name=request.form("name")
atype=request.form("type")
publishing=request.form("publishing")

sql1=""
if name <>"" then
Sql1= Sql1 & "name like '%"&name&"%'"
end if
if atype <>"" then
Sql1= Sql1 & "or type like '%"&atype&"%'"
end if
if publishing <>"" then
Sql1= Sql1 & "or publishing like '%"&publishing&"%'"
end if
response.write sql1
sql="select * from booksx where sql1 "
rs.open sql,conn,1,1
%>

改为
<%
name=request.form("name")
atype=request.form("type")
publishing=request.form("publishing")
'sql1=""
sql="select * from booksx"
if name <>"" then
sql= sql & "w