dim MyFSO,MyFile
Set MyFSO = Server.CreateObject("Scripting.FileSystemObject")
MyFile=trim(rs("picturefile"))//这个数据从数据库中读出,格式是"picture\picfile.gif"
MyFSO.DeleteFile(Server.MapPath(MyFile))
'** 删除记录对应文件模块 Recordset:Recordset1.photourl
Dim XP_Dirtpath, XP_Filepath
Dim XP_fso, XP_msg
XP_Dirtpath = "../upload/" ' **上传文件目录名
XP_Filepath = Server.Mappath(XP_Dirtpath & rs1.Fields.Item("photourl").Value) '** 上传文件名及其绝对路径
Set XP_fso = CreateObject("Scripting.FileSystemObject")
If (XP_fso.FileExists(XP_Filepath)) Then
'** 判断文件是否存在
XP_fso.DeleteFile(XP_Filepath)
'** 删除上传文件
'** 显示文件删除情况
rs1.close
sql="delete FROM photo where photoid="& id
conn.execute sql
response.write("<script language='javascript'>alert('文件及记录均成功删除!');history.go(-1)</script>")
Else
rs1.close
sql="delete FROM photo where photoid="& id
conn.execute sql
response.write("<script language='javascript'>alert('该文件不存在,已经删除数据记录!');history.go(-1)</script>")
End If
End sub
%>