Question

asp中怎么在一个页面查询两个不同的内容并显示

<%maxperss=3%>
<%
dim sql
dim Cid,Bid
Cid=SQLRequestImmit(0,"Get","Cid")
Bid=SQLRequestImmit(0,"Get","Bid")
if Cid="" then
sql="select * from biao1 Where ziduan1 like '%AAA%' order by classid desc"
End if
'response.Write(sql)
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
PageSizes=maxperss
CurrentPage=Request("Page")
if IsNull(CurrentPage) or IsEmpty(CurrentPage) or CurrentPage="" then
CurrentPage=1
end if
%>
<% for i=1 to 3 %>
<% if not rs.eof then %><DIV><%=rs("AAA1") %><DIV><% rs.movenext %>
<% end if %>
<% next%>
<%
rs.close
set rs=nothing
%>
上面代码是从表1里面查询AAA的相关数据，现在想再从同一个表1里面查询有关BBB的所有相关数据并显示，应该怎么改啊？我是菜鸟，请写全点，谢谢大家了。

Answer 1

你可以这样：sql="select * from biao1 Where ziduan1 like '%AAA%' or ziduan1 like '%BBB%' order by classid但这样是夹杂着输出，既有AAA的也有BBB的。如果要单独另外输出可以：sql2="select * from biao1 Where ziduan1 like '%BBB%' order by classid后面再：set rs2=server.createobject("adodb.recordset")
rs2.open sql2,conn,1,1然后一样的通过for输出。

Answer 2

if Cid="" then
sql="select * from biao1 Where ziduan1 like '%AAA%' order by classid sql2="select * from biao1 Where ziduan1 like '%BBB%' order by classid desc"
End if
'response.Write(sql)
set rs=server.createobject("adodb.recordset")set rs2=server.createobject("adodb.recordset")
rs.open sql,conn,1,1rs2.open sql,conn,1,1 这样可以不？？

Answer 3

sql="select * from biao1 Where ziduan1 like '%AAA%' or ziduan2 like '%BBB%' order by classid