Question

高手帮我看看ASP的更新数据库图片的代码对不对

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
set cn = server.CreateObject("ADODB.CONNECTION")
cn.open "DRIVER={Microsoft Access Driver (*.mdb)};dbq="&Server.MapPath("/odb/goo.mdb")
%>
<%
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)
%>
<%
set rec=server.createobject("ADODB.recordset")
rec.Open "update * FROM [image] where id=7",cn,1,3
rec.update
rec("img").appendchunk mydata
rec.update
rec.close
set rec=nothing
set cn=nothing
%>

Answer 1

数据库中只保存图片路径就行了。图片不要存放在数据库中，否则你的数据库会极速增大，影响性能。