% ConnString = "3errres.com.vezos" set nameConn= Server.CreateObject("ADODB.Connection") nameConn.Open ConnString SQL = "SELECT ind, name, mail, site, mes, fecha FROM Libro " SQL = SQL & "ORDER BY Libro.ind DESC" set rs= Server.CreateObject("ADODB.Recordset") rs.CursorLocation = 3 rs.CursorType = 3 rs.open SQL, nameConn rs.pagesize = 5 maxpages=cint(rs.pagecount) maxrecs=cint(rs.pagesize) mypage=request("pagina") If mypage="" then mypage=1 startpos=1 else startpos = ( mypage * maxrecs ) - maxrecs + 1 end if If Not rs.EOF Then rs.absolutepage=mypage End if i=0 mypage=cint(mypage) if maypage= maxpages then endpos=rs.recordcount else endpos= maxrecs * mypage end if numrecs = rs.recordcount If numrecs >0 then if mypage > 1 then prevpage = mypage -1 End If NextPage = Mypage +1 if NextPage <= maxpages Then end if else end if %>
| <%Response.Write (rs.Fields ("name"))%>. <%Response.Write (rs.Fields ("mail"))%>. [<%Response.Write (rs.Fields ("fecha"))%>] | |
<%Response.Write (rs.Fields ("mes"))%> |
| Dtest | |
test |
| Dtest | |
test |