<!--#include file="conn.asp" -->
<%
set rs=conn.execute("select * from youtable")
Set oFileStream = CreateObject ("ADODB.Stream")
oFileStream.Type = 1
set id=rs("id")
set photo=rs("photo")
do while rs.eof=false
oFileStream.Open
oFileStream.Write photo.value
oFileStream.SaveToFile "d:\photo"& id &".jpg",2
oFileStream.close
rs.movenext
loop
set oFileStream=nothing
set photo=nothing
set id=nothing
rs.close
set rs=nothing
%>
....
Set MyStream=Server.CreateObject("Adodb.Stream")
MyStream.Type = 1
While Not Rs.EOF
filename=Rs("filename")
MyStream.Open
MyStream.Write Rs("filedata").GetChunk(Rs("filedata").ActualSize-78)
On error resume next
MyStream.SaveToFile "D:\文件目录\" & filename
Rs.MoveNext
MyStream.close
Wend
Set MyStream=nothing
....
'不过提示意外错误