请教我从access  数据库循环提取图片的路径,怎么只能提取一张啊,而且循环的也只是同样的一张图片,到底是怎么回事啊\
谢谢了

rs.movenext

这是我的代码
<!--#Include FIle="Inc/conndb.asp"-->

    <%                
                        Dim RS3,sql3,content3,ProductID,UploadFiles
                        SET RS3=SErver.CreateObject("ADODB.RECORDSET")
                        sql3="Select * From Product Order BY ProductID DESC "
                        RS3.Open sql3,conn,1,3
                        ProductID=RS3.Fields("ProductID")
                        DefaultPicUrl=RS3.Fields("DefaultPicUrl")
                        DO While NOT RS3.Eof
    %>


            
                    <a href="show.asp?ProductID=<%=ProductID%>"><img src=<%=DefaultPicUrl%> border="0" width="103" height="84"></a>
                        <%
            RS3.MoveNext
            Loop%>
                
        <%
            RS3.close
            %>

<%               
                        Dim RS3,sql3,content3,ProductID,UploadFiles
                        SET RS3=SErver.CreateObject("ADODB.RECORDSET")
                        sql3="Select * From Product Order BY ProductID DESC "
                        rs.Open sql3,conn,1,3
                                         DO While NOT rs.Eof
    %>
                    <a href="show.asp?ProductID=<%=rs("ProductID")
%>"><img src=<%=rs("DefaultPicUrl")
%> border="0" width="103" height="84"></a>
                        <%
            rs.MoveNext
            Loop%>
               
        <%
         rs.close
            %>

你的 rs没有获取下一个值，应放在循环体内

谢谢了
呵呵
解决了