savenewsmod.asp

来自「描述了网上。购物的流程和功能」· ASP 代码 · 共 32 行

<%
if session("admin_name")="" then response.end
%>
<!--#include file="conn.asp"-->
<%
dim sql
       Set cmdTemp = Server.CreateObject("ADODB.Command")
       Set InsertCursor = Server.CreateObject("ADODB.Recordset")
       cmdTemp.CommandText = "SELECT top 1 * FROM news where news_id="&Request("id")
       cmdTemp.CommandType = 1
       Set cmdTemp.ActiveConnection = conn
       InsertCursor.Open cmdTemp, , 1, 3
       InsertCursor("news_title") =Request("title")
       InsertCursor("news_content") =Request("content")
       InsertCursor.Update
'	   response.write InsertCursor("id")
'	   response.End
'	   InsertCursor.movelast
%>
<script language=Javascript>
<!--
alert("修改成功！");
window.location="newsMod.asp?id=<%=Request("id")%>"
-->
</script>
<%
       InsertCursor.close
	   conn.close
       set InsertCursor=nothing
       set conn=nothing
%>