我的图片是以二进制形式存在数据库的，用asp怎样读出？

[LionCsdn]

我的图片是以二进制形式存在数据库的，用asp怎样读出？
读出时能否是它相应的缩略图?

[tianjy]

rs.getchunk(75000)

[flying310]

Response.Expires = 0
Response.Buffer = TRUE
Response.Clear
dim rs
dim cn
dim sql
set rs=server.CreateObject("adodb.recordset")
set cn=Server.CreateObject("ADODB.Connection")
cn.Open "bawei", "sa","itdn1234"

sql="SELECT * FROM pic WHERE imageid = '" & Request.Item("tmid") & "'"
rs.Open sql,cn,1,1


'set rsTemp1=server.CreateObject("Adodb.recordset")
'rsTemp1.open strSQL,Con,3,2
'filesize=rsTemp1("filesize")
Response.ContentType="image/gif"
'Response.BinaryWrite content
'response.contenttype="x-mixed-replace"
Response.BinaryWrite rs("image")
'Response.BinaryWrite content
rs.Close

cn.close
set cn=nothing

[LionCsdn]

我的问题搞定了!