<%
'#################################################################################
'## Copyright (C) 2000 Michael Anderson and Pierre Gorissen
'##
'## This program is free software; you can redistribute it and/or
'## modify it under the terms of the GNU General Public License
'## as published by the Free Software Foundation; either version 2
'## of the License, or any later version.
'##
'## All copyright notices regarding Snitz Forums 2000
'## must remain intact in the scripts and in the outputted HTML
'## The "powered by" text/logo with a link back to
'## http://forum.snitz.com in the footer of the pages MUST
'## remain visible when the pages are viewed on the internet or intranet.
'##
'## This program is distributed in the hope that it will be useful,
'## but WITHOUT ANY WARRANTY; without even the implied warranty of
'## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
'## GNU General Public License for more details.
'##
'## You should have received a copy of the GNU General Public License
'## along with this program; if not, write to the Free Software
'## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
'##
'## Support can be obtained from support forums at:
'## http://forum.snitz.com
'##
'## Correspondence and Marketing Questions can be sent to:
'## reinhold@bigfoot.com
'##
'## or
'##
'## Snitz Communications
'## C/O: Michael Anderson
'## PO Box 200
'## Harpswell, ME 04079
'#################################################################################
%>
<% If Request.Form("RemoveTopic") = "1" then
'Open a connection to the database
'We want to delete our products. The list of ProductIDs that need
'to be deleted are in a comma-delimited list...
Dim strRemoveList
strRemoveList = Request("Remove")
if strRemoveList = "" then 'Do Nothing
Else
'Now, use the SQL set notation to Remove all of the records
'specified by strRemoveList
Dim strSqL
strSqL = "UPDATE " & strTablePrefix & "PM "
strSql = strSql & "SET " & strTablePrefix & "PM.M_OUTBOX = 0 " & _
"WHERE M_ID IN (" & strRemoveList & ")"
my_Conn.Execute (strSql)
%>
<% Response.Write Request("Remove").Count & " message(s) were removed!" %>
Return to your Inbox.
<%
End If
else
Dim strDeleteList
strDeleteList = Request("Delete")
if strDeleteList = "" then
'No messages to delete
%>
You did not select any messages!
Return to your Inbox.
<%
Else
'Now, use the SQL set notation to delete all of the records
'specified by strDeleteList
strSQL = "DELETE FROM " & strTablePrefix & "PM " & _
"WHERE M_ID IN (" & strDeleteList & ")"
my_Conn.Execute (strSql)
%>
<% Response.Write Request("Delete").Count & " Message(s) were deleted!" %>
Return to your Inbox.
<%
End If
end if
%>