<!-- #include virtual="/includes/functions.asp" -->
<%
SectionID = request.querystring("ID")
distributorID = request.querystring("distributorID")

set objDB = OpenDatabase(false)

SQL = "Select * from DistributorContentSections where ID = '" & SectionID & "'"
set rsSection = CreateRecordset(objDB, SQL)

SQL = "Update DistributorContentSections set DisplayOrder = DisplayOrder - 1 where DisplayOrder > " & rsSection("DisplayOrder") & " AND DistributorID = '" & rsSection("DistributorID") & "'"
UpdateDB objDB, SQL

SQL = "Update DistributorContentSections set Active = 0, DisplayOrder = 0 where ID = '" & SectionID & "'"
UpdateDB objDB, SQL

rsSection.close
set rsSection = nothing
objDB.close
set objDB = nothing

response.redirect("../distributorcontent.asp?distributorID="&distributorID)
%>