数据库插入
response.buffer=true
formsize=request.totalbytes
formdata=request.binaryread(formsize)
bncrlf=chrB(13) & chrB(10)
divider=leftB(formdata,clng(instrb(formdata,bncrlf))-1)
datastart=instrb(formdata,bncrlf & bncrlf)+4
dataend=instrb(datastart+1,formdata,divider)-datastart
mydata=midb(formdata,datastart,dataend)
提取数据
rs.Open "select pic from tbl_user where xzqh='"&xzqh&"' and dwbm='"&dwbm&"' and name='"&name&"'", ,3,1
if isnull(rs("pic"))=false then
Response.ContentType = "image/gif"
response.BinaryWrite rs("pic").getChunk(7500000)
else
response.Redirect("../images/wuren.jpg")
end if
rs.close
显示
<img src="*.asp">
rs.Open "select * from tbl_user where name='"&name&"' and xzqh='"&xzqh&"' and dwbm='"&dwbm&"'", ,3,3