再帖完整一点.
<%
page = request("page")
OpenDB
Set rsProduct = Server.CreateObject("ADODB.RecordSet")
strSQL = "........................................................"
rsProduct.open strSQL,DBconn,1,1
If page = "" Then page = 1
If Not rsProduct.Eof Then
rsProduct.pageSize= 6
rsProduct.absolutePage= page
End If
%>
....................................
....................................
<%
i = 0
Do while not rsProduct.Eof and i < rsProduct.pagesize
%>
<% If rsProduct("ProductSmallPic")="" Then response.write("src='img/nopic.gif'") else response.write("src='../product/pic/"&rsProduct("ProductSmallPic")&"'") end if %> width="139" height="100" vspace="3">
[<%=rsProduct("cnproductname")%> ¥ <%=rsProduct("cnproductprice")%>]
">详细介绍 |
<%
rsProduct.movenext
i = i + 1
If i mod 3 = 0 then
response.write("
")
end if
Loop
%>
<% For i = 1 to rsproduct.PageCount If CInt(page) = CInt(i) Then response.write(""&i&" ") Else response.write(""&i&" ") End If Next %>
|