注册 登录
编程论坛 ASP技术论坛

关于循环图片的问题

fuhuijun 发布于 2008-01-12 11:28, 649 次点击
请教我从access  数据库循环提取图片的路径,怎么只能提取一张啊,而且循环的也只是同样的一张图片,到底是怎么回事啊\
谢谢了
5 回复
#2
skybirdzw2008-01-12 11:29
回复 1# 的帖子
rs.movenext
#3
fuhuijun2008-01-12 11:38
这是我的代码
<!--#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
            %>
#4
skybirdzw2008-01-12 12:13
回复 3# 的帖子
<%               
                        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
            %>
#5
skybirdzw2008-01-12 12:14
回复 3# 的帖子
你的 rs没有获取下一个值,应放在循环体内
#6
fuhuijun2008-01-12 12:34
谢谢了
呵呵
解决了
1