雪花秀三件套功效:在ASP中,我想让数据库中所有的图片都输 出来,可结果就输出一张,和序如下,原因????
来源:百度文库 编辑:杭州交通信息网 时间:2024/06/06 05:45:33
<%
dim rs,sql
sql="select * from photo order by id"
set rs=conn.execute(sql)
do while not rs.eof
Response.ContentType ="image/jpeg"
Response.BinaryWrite rs("img")
rs.movenext
loop
rs.close
set rs=nothing
%>
dim rs,sql
sql="select * from photo order by id"
set rs=conn.execute(sql)
do while not rs.eof
Response.ContentType ="image/jpeg"
Response.BinaryWrite rs("img")
rs.movenext
loop
rs.close
set rs=nothing
%>
sql="select * from photo order by id"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,1
用这种方式打开试试!!