%@LANGUAGE="VBSCRIPT"%> <% '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ' Spd E-Letter v4 ' © 2001, 2002 PensaWorks, inc. ' For help with this program, please visit http://www.pensaworks.com '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Dim Access : Access = "User" Dim Nav3 : Nav3 = "4" %> <% if (request("ListID") <> "" and IsNumeric(request("ListID"))) then listID = cint(request("ListID")) else listID = 0 if listID = 0 then response.redirect "message.asp?msg=20" if not allowedList(listID, allowedLists) then response.redirect "message.asp?msg=49" set rsList = server.createobject("ADODB.Recordset") rsList.activeconnection = mlConn rsList.source = "SELECT * FROM ML_Lists WHERE ListID = " & listID rsList.cursortype = 3 rsList.open() if (rsList.EOF) then response.redirect "message.asp?msg=20" if request("action") = "edit" then if (request("ListName") = "" or request("ListAdminEmail") = "") then response.redirect "message.asp?msg=19" Set cmdTemp = Server.CreateObject("ADODB.Command") cmdTemp.ActiveConnection = mlConn ' Open Database, and Update Set rsUpdate = Server.CreateObject("ADODB.RecordSet") rsUpdate.ActiveConnection = mlConn cmdTemp.CommandText = "SELECT * FROM ML_Lists WHERE ListID = " & ListID rsUpdate.Open cmdTemp, ,1,3 rsUpdate("ListName") = Request("Listname") rsUpdate("PublicList") = Request("PublicList") rsUpdate("ListAdminEmail") = Request("ListAdminEmail") rsUpdate("BCCListAdmin") = Request("BCCListAdmin") rsUpdate("DoubleOptin") = Request("DoubleOptin") rsUpdate("DoubleOptout") = Request("DoubleOptout") rsUpdate("ListDescription") = Request("ListDescription") rsUpdate("HeaderText") = Request("HeaderText") rsUpdate("FooterText") = Request("FooterText") rsUpdate("HeaderHTML") = Request("HeaderHTML") rsUpdate("FooterHTML") = Request("FooterHTML") rsUpdate("OptinMessage") = Request("OptinMessage") rsUpdate("OptoutMessage") = Request("OptoutMessage") rsUpdate("SWE") = Request("SWE") rsUpdate("SubscribeSubject") = Request("SubscribeSubject") rsUpdate("SubscribeText") = Request("SubscribeText") rsUpdate("SubscribeHTML") = Request("SubscribeHTML") rsUpdate("SUE") = Request("SUE") rsUpdate("UnsubscribeSubject") = Request("UnsubscribeSubject") rsUpdate("UnsubscribeText") = Request("UnsubscribeText") rsUpdate("UnsubscribeHTML") = Request("UnsubscribeHTML") rsUpdate.Update rsUpdate.Close() Set rsUpdate = nothing response.redirect "message.asp?msg=13&list=" & Server.URLEncode(rsList("ListName")) end if %>
|
Edit List |
||
|
|