showphoto.asp

企业办公自动化管理系统 asp+sql server 2005

<!--#include file="include/opendb.asp"-->
<% 
set conn=opendb()
Set rs=Server.CreateObject("ADODB.recordset")
sql="select photo from personinf where id=" & trim(request("id")) 
rs.open sql,conn,1,1 
Response.ContentType = "image/*" 
Response.BinaryWrite rs("photo").getChunk(7500000) 
'rs.close 
'set rs=nothing 
'set conn=nothing 
%>