分页显示的 记录反向叠加，就是page1里包含了page1,page2,page3...以下所有的 记录，
而page2里则包含了page2,page3,page4..以下的所有内容，请问大家这是什么问题引起的？？？该怎么解决？？？

我在线等~~~~

是没有限制循环部分吧.
while not(rs.eof) and i<rs.pagesize
....
...
..
i=1+1
rs.movenext
wend

循环也限制了，不过是在另一个函数里.
sub class_detail_show(shopCartTableWidth,showProductRowNum,imageHeight,big_class_type,second_class_type,maxPerPage)
    sql="select * from product_detail where "
    if big_class_type<>"" then
    sql=sql&"big_class_type='"&big_class_type&"'"
    end if
    if second_class_type<>"" then
    sql=sql&" and second_class_type='"&second_class_type&"'"
    end if
    sql=sql&" order by id desc"
    
    if not isempty(request.QueryString("pageNo")) then
        pageNo=cint(request.QueryString("pageNo"))
    else
        pageNo=1
    end if

    set rs=server.CreateObject("adodb.recordset")
    rs.open sql,conn,1,1
    if err.number<>0 then
        response.Write "数据库暂无纪录!"
        response.End()
    end if
    if rs.eof and rs.bof then
        response.Write "数据库无商品!"
        response.End()
    else
        recordTotal=rs.recordcount
        if pageNo<1 then pageNo=1
            if (pageNo-1)*maxPerPage>recordTotal then
                if (recordTotal mod maxPerPage)=0 then
                    pageNo=recordTotal\maxPerPage
                else
                    pageNo=recordTotal\maxPerPage+1
                end if
            end if
            if pageNo=1 then
                second_class_type_content shopCartTableWidth,showProductRowNum,imageHeight,rs,bookmark
            else
                if (pageNo-1)*maxPerPage<recordTotal then
                    rs.move (pageNo-1)*maxPerPage
                    bookmark=rs.bookmark
                    response.Write bookmark&(pageNo-1)*maxPerPage
                    second_class_type_content shopCartTableWidth,showProductRowNum,imageHeight,rs,bookmark
                else
                    pageNo=1
                    second_class_type_content shopCartTableWidth,showProductRowNum,imageHeight,rs,bookmark
                end if
            end if
        end if    
end sub

sub second_class_type_content(shopCartTableWidth,showProductRowNum,imageHeight,rs,bookmark)    
    response.Write "<table width='"&shopCartTableWidth&"' border='0' cellpadding='0' cellspacing='0' align='center'>"
        j=0
        response.Write bookmark
        do while not rs.eof
            j=j+1
            'response.Write rs("name")
            'rs.movenext
        'loop
        'response.End()
            if(j mod showProductRowNum)=1 then
                strTemp="<tr><td colspan='"&(showProductRowNum*2-1)&"' height='1' background='image/global.gif'><td><tr>"
                strTemp=strTemp&"<tr>"
        response.Write strTemp
            end if
            response.Write "<td align='center' width='"&cint(shopCartTableWidth/showProductRowNum-0.5)&"'>"
            
            if rs("img_src")="noImg" then
                img_src="image/noImg.gif"
            else
                img_src="image/"&rs("img_src")
            end if
    
    %>
            <table width="100%" border="0" cellpadding="5" cellspacing="0" align="center">
            <tr>
            <td width="90%" align="center"><img src="<%=img_src%>" border="0" height="<%=imageHeight%>" width="100"></a></td>
            </tr>
            <tr>
                <td class="jj2" colspan="2" align="center"><b><u><%=rs("name")%></u></b></td>
            </tr>
            <tr>
                <td align="center"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                  <tr>
               <td align="center" style="font-size:12px"><font color="#666666">市场价:<%=rs("market_price")%>元</font></td>
               <td align="center" style="font-size:12px">商城价:<font color="#FF0000"><%=rs("member_price")%>元</font></td>
                  </tr>
                </table></td>        
            </tr>
            <tr>
            <td>
                <table width="100%" border="0" cellspacing="0" cellpadding="0">
                  <tr>
               <td align="center" style="font-size:14px">我要购买</td>
               <td align="center" style="font-size:14px">加入收藏</td>
                  </tr>
                </table>
            </td>
            </tr>
            </table>
    <%
            response.Write "</td>"
            if (j mod showProductRowNum)=0 then
                response.Write "</tr>"
            else
                response.Write "<td background='image/point.gif' width='1'></td>"
            end if
            rs.movenext
        loop
            k=(j-1) mod showProductRowNum
            if k<>0 then
                response.Write "<td colspan="&(showProductRowNum-k)&" width="&(cint(100/showProductRowNum)*(showProductRowNum-k))&">&nbsp;</td>"
                response.Write "</tr>"
            end if
        response.Write "</table>"    
end sub

我找到了 ，是没加那个限制页面容量的条件。pagesize>0 谢谢你！

你的分页代码也太复杂了,看了半天硬是没看明白
   rs.move (pageNo-1)*maxPerPage
可能错在这里吧
   rs.move (pageNo-1)*maxPerPage,1