asp 读取sql(image类型)的图片,弄了好久也不显示,各位帮看看啊
show.asp --------------------------------------
<%
set conn=server.CreateObject("adodb.connection")
conn.connectionstring="driver={sql server};server=.;uid=sa;pwd=;database=vote;"
conn.open
set rt=server.CreateObject("adodb.recordset")
rt.open "votemaster",conn,1,1
do until rt.eof
%>
<img src="load.asp?id=<% =rt("voteid")%>" alt="这是一张图片" />
<%
rt.movenext
loop
rt.close
set rt=nothing
conn.close
set conn=nothing
%>
load.asp -----------------------------------------
<%
response.Expires=0
response.Buffer=true
response.Clear()
set conn=server.CreateObject("adodb.connection")
conn.connectionstring="driver={sql server};server=.;uid=sa;pwd=;database=vote;"
conn.open
set rt=server.CreateObject("adodb.recordset")
sql="select votepic from votemaster where voteid like '"&request.QueryString("id")&"'"
rt.open sql,conn,1,1
response.ContentType="image/*"
response.BinaryWrite rt("votepic").getchunk(7500000)
rt.close
set rt=nothing
conn.close
set conn=nothing
%>
参考答案:字段名
路径