itemdelete.asp

来自「一个ＡＳＰ网站博克程序」· ASP 代码 · 共 32 行

<% Option Explicit %>
<!-- #Include File = "common/LarrixDBMS.asp" -->
<!-- #Include File = "object/Comment.asp" -->

<%
	If Session("Passport") = "" Or Session("Passport") <= 0 Or Session("UsrLevel")="" Then
		Response.Redirect("../Default.asp")
	End If
%>

<%
	If Trim(Request.QueryString("id")) = "" Or IsNumeric(Trim(Request.QueryString("id"))) = False Then
		Response.Redirect("Default.asp")
	End If
%>

<%
	Dim objDBMS
	Dim objComment
	Set objDBMS = New LarrixDBMS
	objDBMS.Open "SELECT * FROM [Items] WHERE [ItemID]=" & Trim(Request.QueryString("id")) & " AND [MemberID]=" & Session("Passport"), 3
	If Not (objDBMS.objRSET.BOF And objDBMS.objRSET.EOF) Then
		Set objComment = New Comment
		objComment.ItemDelete objDBMS.objRSET("ItemID")
		Set objComment = Nothing
		objDBMS.objRSET.Delete
		objDBMS.objRSET.Update
	End If
	objDBMS.Close
	Set objDBMS = Nothing
	Response.Redirect("Default.asp")
%>