|
|
|
|
 |
|
채영이 / 2001-03-26 / 오후 10:58:11 / 203.255.3.190
조회수 : 154
|
| [질문] 정수님&채영님 페이지 순차번호메기기 소스인데 |
> 페이지 순차적으로 메기기인데요
> 첫페이지 순차하고 두번째 페이지 순차하고
> 똑같아요 ㅡㅡ;
> 첫페이지 4,3,2,1
> 두번째 페이지 4,3,2,1
> 이렇게요 리스트 소스는 아래와 같습니다.
> <======================>
> <%
> if request("page")="" then
> page=1
> count = coot
> else
> page = Request("page")
>
> end if
>
> Dim PageSize
> <===========DB연결부분==========>
> rs.PageSize = 2
> rs.Open SQL,db,1
>
> count = rs.recordcount
>
>
>
> %>
> <html>
> <head>
> <title>게시판</title>
> <link rel="stylesheet" href="style1.css">
> </head>
> <body bgcolor="#FFFFFF">
> <% if rs.BOF or rs.EOF then %>
> <!--데이터가 없을때 처리부분-->
> <!-- 데이터가 있을때 처리부분 -->
> <%
> else
> '페이지
> totalpage = rs.pagecount
> rs.absolutepage = page
> %>
> <div align="center"><center>
> <p align="center"><font color="#004080"><strong><big>채널투유게시판</big></strong></font><br>
> </p>
> </center>
> </div>
> <div align="center">
> <center>
> <table border="0" cellspacing="0" width="660">
> <tr border=1>
> <td colspan="6" align="left" height="10"><font face="돋움" size="2" color="#000000"><a href="Write.htm">WEITE</a></font> </td>
> <td align="left" height="10" width="11%"><a href="admin.asp"><font size="1">ADMIN</font></a></td>
> </tr>
> <tr border=1>
> <td width="10%" align="center" height="20" bgcolor="#CCCCCC">번호</td>
> <td width="5%" align="center" height="20" bgcolor="#999999">선택</td>
> <td width="5%" align="center" height="20" bgcolor="#B6B6B6"><img src="images/disk.gif" width="11" height="11"></td>
> <td width="36%" align="center" height="20" bgcolor="#CCCCCC">제 목</td>
> <td width="18%" align="center" height="20" bgcolor="#CCCCCC">글쓴이</td>
> <td width="18%" align="center" height="20" bgcolor="#CCCCCC">날짜</td>
> <td width="8%" align="center" height="20" bgcolor="#CCCCCC">조회수</td>
> </tr>
> <tr height="1">
> <td colspan="7" bgcolor="#666666"></td>
> </tr>
> <%
> i = 1
>
> Do until rs.EOF or i > rs.PageSize
> %>
> <tr onMouseOver="this.style.background = 'F1F1EE';" onMouseOut="this.style.background='ffffff';">
> <td width="10%" align="center" height="20"><%=count%></td>
> <td width="5%" align="center" height="20" bgcolor="#F8E6C2">
> <input type="checkbox" name="del" value = "5">
> </td>
> <td align="center" height="20" width="5%" bgcolor="#F8E6C2"><img src="images/disk.gif" width="11" height="11"></td>
> <td align="center" height="20" width="29%"><a href="content.asp?idx=<%=rs("board_idx")%>"><%=rs("title")%></a></td>
> <td width="20%" align="center" height="20"><a href="mailto:<%=rs("email")%>"><%=rs("name")%></a></td>
> <td width="20%" align="center" height="20"><%=left(rs("writeday"),10)%></td>
> <td width="11%" align="center" height="20"><%=rs("readnum")%></td>
> </tr>
> <%
> count = count - 1
> ct = ct - 1
> rs.MoveNext
> i=i+1
>
> loop
>
> %>
> </table>
> </center></div>
> <center>
> <table border="0" cellspacing="0" width="660">
> <tr height="1">
> <td colspan="5" bgcolor="#CCCCCC"></td>
> </tr></table>
> <br>
> </center>
> <center>
>
> <% if page <> 1 then%>
> <<a href="list.asp?page=<%=page-1%>">이전페이지</a> >
> <% else %>
> <font color="#999999"><이전페이지></font>
> <% end if %>
> <%=page%> / <%=totalpage%>
> <% if Cint(page) <> Cint(totalpage) then%>
> < <a href="list.asp?page=<%=page+1%>">다음페이지</a> >
> <% else %>
> <font color="#999999"><다음페이지></font>
> <% end if %>
>
> </center>
>
> <div align="center"><center>
> <form method="POST" action="search_result.asp">
> <table border="0" cellspacing="0" width="500">
> <tr>
>
> <td>
> <div align="center">
> <p><font color="#666666" face="Century Gothic">Search</font><font color="#004080" face="Century Gothic">
> </font>
> <select name="search" size="1" style="font-family: 돋움체">
> <option value="title">글제목</option>
> <option value="name">글쓴이</option>
> <option value="content">글내용</option>
> </select>
> <input type="text" name="SearchString" size="20" style="border: 1px dashed"><input type="submit" value=" 검 색 " name="btn" style="background-color: rgb(238,238,238); color: rgb(0,47,94); font-weight: bolder"> <center></td>
> </tr>
>
> </table></form>
> </center></div>
>
> <% end if%>
> </body>
> </html>
> <%
> rs.Close
> db.Close
> Set rs = Nothing
> Set db = Nothing
> %>
-----------------------------------------------------------
count = rs.recordcount
이 부분이 총개수를 구하는것 같은데요...
이 값은 1페이지던 2페이지던 값이 변하질 않을테니
당연히 페이지를 넘기더라도.... 값이 변하지 않겠지요...
앞에 정수님이 완전한 해결책과 알고리즘이 담긴 소스를
소개했던걸로 기억하는데요....
참고하세요...
|
|
|
|