方案一
复制代码代码如下: <!-#include file = "conn.asp"->
-
OWEN1 = คำขอ ("OWEN1")
OWEN2 = คำขอ ("OWEN2")
-
<TableWidth = "95%" border = "0" cellpadding = "0" cellspacing = "0">
-
หน้า = CLNG (คำขอ ("หน้า"))
setRs = server.createObject ("adodb.recordset"))
ifowen1 <> "" Andowen2 <> ""
SQL = "SELECT*FRONNEWSWHEREBIGCLASSNAME = '" & OWEN1 & "' และ SMALLCLASSNAME = '" OWEN2 & "' ORDERBYIDDESC"
Rs.opensql, Conn, 1,1
elsefowen1 <> "" แล้ว
sql = "select*fromnewswherebigclassname = '" & owen1 & "' orderbyiddesc"
Rs.opensql, Conn, 1,1
endif
ifrs.eofandrs.bofthen
Response.write ("暂时没有记录")
อื่น
-
-
Rs.Pagesize = 15
ifpage = 0thenpage = 1
หน้า = rs.pagecount
ifpage> pagesthenpage = หน้า
rs.absolutePage = หน้า
forj = 1tors.pagesize
if (j-1) mod3 = 0thenResponse.write ("<tr>")
-
<tdheight = "24" Align = "Center">
<divalign = "center"> <imgsrc = "uppic/<%= rs (" firstimagename ")%>" width = "130" ความสูง = "100" border = "0"/> <ahref = "onews.asp? id = <%= rs (" id ")
<%= rs ("title")%> </a> </div> </td>
-
ifjmod3 = 0thenResponse.write ("</tr>")
Rs.Movenext
ifrs.eofthenexitfor
ต่อไป
-
-
endif
Rs.close
setrs = ไม่มีอะไร
-
</table>
方案二、
复制代码代码如下: <!-#include file = "conn.asp"->
-
OWEN1 = คำขอ ("OWEN1")
OWEN2 = คำขอ ("OWEN2")
-
<TableWidth = "95%" border = "0" cellpadding = "0" cellspacing = "0">
-
หน้า = CLNG (คำขอ ("หน้า"))
setRs = server.createObject ("adodb.recordset"))
ifowen1 <> "" Andowen2 <> ""
SQL = "SELECT*FRONNEWSWHEREBIGCLASSNAME = '" & OWEN1 & "' และ SMALLCLASSNAME = '" OWEN2 & "' ORDERBYIDDESC"
Rs.opensql, Conn, 1,1
elsefowen1 <> "" แล้ว
sql = "select*fromnewswherebigclassname = '" & owen1 & "' orderbyiddesc"
Rs.opensql, Conn, 1,1
endif
ifrs.eofandrs.bofthen
Response.write ("暂时没有记录")
อื่น
-
-
Rs.Pagesize = 15