请教如何在单表单段查询上加入多段查询?
请问如何在以下的单表单段(question)关键查询里加入“question1”、“question2”二个段进行多段关键字查询?谢谢!<%
if request("userid123")="" then
sql="select * from users order by id desc"
else
sql="select * from users where question='"&request("userid123")&"'"
end if
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "<p align='center'>你查的这个内容不存</p>"
else
totalPut=rs.recordcount
totalPut=rs.recordcount
if currentpage<1 then
currentpage=1
end if
if (currentpage-1)*MaxPerPage>totalput then
if (totalPut mod MaxPerPage)=0 then
currentpage= totalPut \ MaxPerPage
else
currentpage= totalPut \ MaxPerPage + 1
end if
end if
if currentPage=1 then
showpage totalput,MaxPerPage,"Find-8a.asp"
showContent
showpage totalput,MaxPerPage,"Find-8a.asp"
else
if (currentPage-1)*MaxPerPage<totalPut then
rs.move (currentPage-1)*MaxPerPage
dim bookmark
bookmark=rs.bookmark
showpage totalput,MaxPerPage,"Find-8a.asp"
showContent
showpage totalput,MaxPerPage,"Find-8a.asp"
else
currentPage=1
showpage totalput,MaxPerPage,"Find-8a.asp"
showContent
showpage totalput,MaxPerPage,"Find-8a.asp"
end if
end if
end if
sub showContent
dim i
i=0
%>