Reply to thread

Message: [QUOTE="{ CrossFire }, post: 1595284"] Hi. First I am English a little :). My Problem: I want to paging this page with MS Access.But i don't it.How to do paging my code.Thanks everybody already now. My Codes: Note : This is an include file. <% if request.QueryString("CatID")<>"" then set rs = conn.execute("Select * From urunler Where CategoryID=" & request.QueryString("CatID")) end if %> <table style="width:520px;" cellspacing="0" cellpadding="0" align="right"> <tr> <td class="uyeback">TEST</td> </tr> <tr> <td class="dotbar" style="background-color:#FFF"></td> </tr> <tr> <td>  <table cellpadding="0" cellspacing="0" style="width:520px;"> <tr> <td style="background-color:#DDE6EC;height:5px;padding-left:10px;">Alt Kategoriler</td> </tr> <tr> <td class="dotbar" style="background-color:#FFF;height:5px;"></td> </tr> </table>  </td> </tr> <tr> <td style="background-color:#FF6600;height:17px;"></td> </tr> <tr> <td class="dotbar"></td> </tr> <tr> <td> <table cellpadding="0" cellspacing="0" style="width:520px;"> <tr> <td style="background-color:#F2F2F2;height:20px;text-align:center;"> Page : previous | next</td> </tr> <tr> <td class="dotbar" style="background-color:#FFF;height:5px;"></td> </tr> </table> </td> </tr> <tr> <td style="background-image:url('images/dot_bg.gif');height:11px;"></td> </tr> <tr> <td>  <% iCount = 0 Do while not rs.eof If Eval(iCount\2 = iCount/2) Then 'determine if the number is odd or even %> <table style="width:520px;" cellspacing="0" cellpadding="0"> <tr> <td> <table cellpadding="0" cellspacing="0" style="width:520px;"> <tr> <td style="vertical-align:top;"> <table style="background-color:#f2f2f2;border:0px;width:250px;" cellpadding="8" cellspacing="5"> <tr> <td style="background-color:#ffffff"> <table align="center" style="background-color:#ffffff;width:220px;" cellpadding="0" cellspacing="0"> <tr> <%if rs("urunkresim")<>"" then%> <td style="vertical-align:top; width:90px;"> <a href="#"> <img src="<%=rs("urunkresim")%>" style="border:0px; width:80px;height:80px;" alt=""/></a> </td> <%end if%> <td style="vertical-align:top; width:130px;"> <table cellpadding="0" cellspacing="0" style="width:130px;"> <tr> <td class="headergreen"><%=rs("urunadi")%></td> </tr> <tr> <td style="background-image:url('images/dot_bar.gif');height:5px;"></td></tr> <tr> <td><%=rs("urunkisayazi")%></td></tr><tr> <td style="background-image:url('images/dot_bar.gif');height:5px;"></td></tr> <tr><td> <table cellpadding="0" cellspacing="0" style="width:130px;"> <tr><td><a href="#"> <img src="images/detay.gif" style="border:0px;" alt=""/></a></td> </tr> </table></td> </tr> <tr> <td style="height:5px; background-image:url('images/dot_bar.gif');"> </td> </tr> <tr> <td> <table cellpadding="0" cellspacing="0" style="width:130px"> <tr> <td class="price">Fiyatý : <%=rs("urunfiyat")%> YTL</td></tr> </table></td> </tr> </table></td> </tr> </table></td> </tr> </table> </td> <td style="width:20px;"></td> <%ELSE%> <td style="vertical-align:top;"> <table style="background-color:#f2f2f2;border:0px;width:250px;" cellpadding="8" cellspacing="5"> <tr> <td style="background-color:#ffffff"> <table align="center" style="background-color:#ffffff;width:220px;" cellpadding="0" cellspacing="0"> <tr> <%if rs("urunkresim")<>"" then%> <td style="vertical-align:top; width:90px;"> <a href="#"> <img src="<%=rs("urunkresim")%>" style="border:0px; width:80px;height:80px;" alt=""/></a> </td> <%end if%> <td style="vertical-align:top; width:120px;"> <table cellpadding="0" cellspacing="0" style="width:130px;"> <tr> <td class="headergreen"><%=rs("urunadi")%></td> </tr> <tr> <td style="background-image:url('images/dot_bar.gif');height:5px;"></td></tr> <tr> <td><%=rs("urunkisayazi")%></td></tr><tr> <td style="background-image:url('images/dot_bar.gif');height:5px;"></td></tr> <tr><td> <table cellpadding="0" cellspacing="0" style="width:130px;"> <tr><td><a href="#"> <img src="images/detay.gif" style="border:0px;" alt=""/></a></td> </tr> </table></td> </tr> <tr> <td style="height:5px; background-image:url('images/dot_bar.gif');"> </td> </tr> <tr> <td> <table cellpadding="0" cellspacing="0" style="width:130px"> <tr> <td class="price">Fiyatý : <%=rs("urunfiyat")%> YTL</td></tr> </table></td></tr></table></td></tr></table></td></tr></table> </td></tr></table> </td> </tr> <tr> <td style="background-image:url('images/dot_bg.gif');height:11px;"></td></tr> <% End If iCount = iCount +1 'increment the counter rs.movenext loop response.write "</table>" %> </table>  </td> </tr> <tr> <td> <table cellpadding="0" cellspacing="0" style="width:520px;"> <tr> <td style="background-color:#FFF"> </td> </tr> <tr> <td style="background-color:#F2F2F2;height:20px;text-align:center;">Sayfa : | 1 |</td> </tr> <tr> <td class="dotbar" style="background-color:#FFF;height:5px;"></td> </tr> </table></td> </tr> <tr> <td style="background-image:url('images/dot_bg2.gif');height:21px;"></td> </tr> </table> [/QUOTE]

Verification