saledeletedb.asp

来自「一个用asp实现简单的小型OA系统」· ASP 代码 · 共 11 行

<!--#include file="session.asp"-->
<!--#include file="Connections/conn.asp" -->
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open MM_conn_STRING
id=request.QueryString("id")
    sql = "DELETE FROM Sales WHERE Saleid = "&id
    Set rs = conn.Execute(sql)
    response.Write "<script>alert('删除成功！');window.location.href='salelist.asp';</script>"
%>