itemmodifyupdate.asp

一个ＡＳＰ网站博克程序

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

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

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

<%
	Dim objDBMS
	Dim intCount, strValue
	For intCount = 1 To Request.Form("value").Count
  		strValue = strValue & Request.Form("value")(intCount)
	Next
	Set objDBMS = New LarrixDBMS
	objDBMS.Open "SELECT * FROM [Items] WHERE [ItemID]=" & Trim(Request.Form("id")) & " AND [MemberID]=" & Session("Passport"), 3
	If Not (objDBMS.objRSET.BOF And objDBMS.objRSET.EOF) Then
		objDBMS.objRSET("CategoryID").Value = Trim(Request.Form("category"))
		objDBMS.objRSET("ItemLAB").Value = Trim(Request.Form("label"))
		objDBMS.objRSET("ItemVAL").Value = strValue
		objDBMS.objRSET("ItemDTM").Value = Date()
		objDBMS.objRSET("ItemURL").Value = Request.ServerVariables("REMOTE_ADDR")
		objDBMS.objRSET("ItemTOP").Value = CBool(Trim(Request.Form("top")) = "1")
		objDBMS.objRSET("ItemHID").Value = CBool(Trim(Request.Form("hide")) = "1")
		objDBMS.objRSET("ItemLOC").Value = CBool(Trim(Request.Form("lock")) = "1")
		objDBMS.objRSET.Update
	End If
	objDBMS.Close
	Set objDBMS = Nothing
	Response.Redirect("Default.asp")
%>