asp读取oracle表blob类型的字段

[lusawlx]

数据库类型为oracle
有一个表image
image中有一个字段pic，类型为blob
页面的内容由别人存入的，应该是相片之类的信息
请问我应该如果读出这个字段的内容

[md5e]

数据是文件流,可以用二进制读出来

[lusawlx]

怎么没人来的。。。。。

[wcwtitxu]

试下:

<%
Dim conn, rs
Set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString = "UID=*****;PWD=*****;driver={Microsoft ODBC for Oracle};SERVER=*****;"
conn.Open

Set rs = Server.CreateObject("ADODB.RecordSet")
rs.open "SELECT [pic] FROM [image] WHERE [id]=1", conn, 1, 1
Response.ContentType = "image/*"
Response.BinaryWrite rs("img").getChunk(7500000)
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
%>

[wcwtitxu]

更正:

Response.BinaryWrite rs("pic").getChunk(7500000)

[lusawlx]

快点来人啊.......

[lusawlx]

???????????????????????/

[lusawlx]

改成这样，一运行就出来，文件下载-安全警告　的对话框

[lusawlx]

把Response.ContentType = "image/*"改为
Response.ContentType = "image/jpeg"
运行出现乱码

??缲考龛)遦??AP/鶵枝h燀s篼闲R嫻纭鼌AG螗a???l燓z~偁|k?鯂?？謵r??萉錾绉?淨巻€???绉?鹐屈觚AM??煻N3蠸M翥?猍隡b罍

[lusawlx]

somebody come in please

[lusawlx]

顶