<!--#include file=conn.asp-->
<!--#include file=usercookies.asp-->
<%dim id,rs,sql,rs1,sql1
id=request("id")

'''''''''''''''''''''
'通过FSO组件删除文件'
'''''''''''''''''''''
sql1="select xinxipic from FOX_xinxi where id="&request("id")
set rs=conn.execute(sql1)
Server.CreateObject("Scripting.FileSystemObject").GetFile(server.mappath("xinxiupfiles")&"\"&rs("xinxipic")).delete
''''''''''''''''''''''
'删除数据记录'''''''''
''''''''''''''''''''''
sql="Delete from FOX_xinxi where id="&request("id")
conn.execute sql
 response.write "<script>alert('删除成功！');this.location.href='xinxima.asp?ts=1';</SCRIPT>"
response.end
Response.Redirect "xinxima.asp?ts=1"
%>
</body></html>