方案一
复制代码代码如下: <!-#incluirfile = "Conn.asp"->
<%
Owen1 = solicitação ("Owen1")
Owen2 = solicitação ("Owen2")
%>
<tablewidth = "95%" border = "0" CellPadding = "0" CellSpacing = "0">
<%
página = clng (request ("página")))
Setrs = server.createObject ("adodb.recordset")
ifowen1 <> "" Andowen2 <> "" então
sql = "Selecione*FromnewswherebigclassName = ''" & Owen1 & "'andsmallClassName ='" & Owen2 & "OrderByidDesc"
Rs.opensql, Conn, 1,1
elseifowen1 <> "" então
sql = "Selecione*FromnewswherebigclassName = '" "& Owen1 &" OrderByiddesc "
Rs.opensql, Conn, 1,1
endif
ifrs.eofandrs.bofthen
Response.Write ("暂时没有记录")
outro
%>
<%
rs.pagesize = 15
ifpage = 0ThenPage = 1
Páginas = Rs.Pagecount
ifpage> pagesthenpage = páginas
rs.absolutePage = página
forj = 1Tors.Pagesize
if (j-1) mod3 = 0ThenResponse.write ("<tr>")
%>
<tdHeight = "24" align = "Center">
<Divalign = "Center"> <imgsrc = "uppic/<%= rs (" FirstImageName ")%>" width = "130" altura = "100" border = "0"/> <href = "Onews.asp ?sp?
<%= Rs ("title")%> </a> </div> </td>
<%
ifjmod3 = 0ThenResponse.write ("</tr>")
rs.movenext
ifrs.eofthenexitfor
próximo
%>
<%
endif
rs.close
setrs = nada
%>
</tabela>
方案二、
复制代码代码如下: <!-#incluirfile = "Conn.asp"->
<%
Owen1 = solicitação ("Owen1")
Owen2 = solicitação ("Owen2")
%>
<tablewidth = "95%" border = "0" CellPadding = "0" CellSpacing = "0">
<%
página = clng (request ("página")))
Setrs = server.createObject ("adodb.recordset")
ifowen1 <> "" Andowen2 <> "" então
sql = "Selecione*FromnewswherebigclassName = ''" & Owen1 & "'andsmallClassName ='" & Owen2 & "OrderByidDesc"
Rs.opensql, Conn, 1,1
elseifowen1 <> "" então
sql = "Selecione*FromnewswherebigclassName = '" "& Owen1 &" OrderByiddesc "
Rs.opensql, Conn, 1,1
endif
ifrs.eofandrs.bofthen
Response.Write ("暂时没有记录")
outro
%>
<%
rs.pagesize = 15