最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
asp 删除数据记录并且同时删除文件图片
时间:2022-07-02 23:00:54 编辑:袖梨 来源:一聚教程网
Id=Request("Id")
If Id="" Then
Response.Write("")
Else
Id=Split(Id,",")
For i=0 to UBound(Id)
set oRs=SerVer.CreateObject("Adodb.recordset")
sSql = "SELECT D_SavePathFileName FROM "&data&" WHERE ID="&id(i)&""
oRs.Open sSql, Conn, 0, 1
If Not oRs.Eof Then
asSavePathFileName = oRs("D_SavePathFileName")
Else
asSavePathFileName=""
End If
oRs.Close
Set oRs=Nothing
Dim aSavePathFileName
if len(aSavePathFileName)>0 then
aSavePathFileName = Split(asSavePathFileName, "|")
Dim n
For n = 0 To UBound(aSavePathFileName)
' 按路径文件名删除文件
Call DoDelFile(aSavePathFileName(n))
Next
'删除文章
Conn.Execute("delete from Article where id="&id(i)&"")
Next
end if
Sub DoDelFile(sPathFile)
'On Error Resume Next
Dim oFSO
Set oFSO = Server.CreateObject("Scripting.FileSystemObject")
if objFSO.fileExists(Server.MapPath(sPathFile)) then
oFSO.DeleteFile(Server.MapPath(sPathFile))
end if
Set oFSO = Nothing
End Sub
相关文章
- 三国望神州张飞技能如何 12-31
- 闲鱼网页版直达-闲鱼网页版一键登录 12-31
- dota2 7.35更新日志一览 7.35更新内容汇总 12-31
- 羞羞漫画在线观看入口免费下载安装-羞羞漫画在线观看入口高清版本 12-31
- 剑与远征启程翼技能有哪些效果 12-31
- 代练通网页版一键直达-代练通平台官网极速入口 12-31