<%
folderspec="c:\upload"
Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.GetFolder(folderspec)
Set fc = f.Files
'循环列出所有文件名,与数据库中保存的数据做比较
For Each fd in fc
sql="select id from tablename where filenum='"&fd.name&"'"
rs.open sql,cn,1,1
if rs.eof then
fso.DeleteFile("c:\upload\"&fd.name)
end if
rs.close
next
set objtools=server.createobject("mswc.tools")
set myfileobject=server.createobject("scripting.filesystemobject")
do while not rs.eof
if objtools.fileexists(rs("filenum"))=-1 then
set myfilepath=myfileobject.getfile(rs("filenum"))
myfilepath.delete
myfilepath.close
end if
rs.MoveNext()
loop