%@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("Action") = "add_list" Then ListName = Replace(request("ListName"),"'","''") ListAdminEmail = Replace(request("ListAdminEmail"),"'","''") if (ListName = "" or ListAdminEmail = "") then response.redirect "message.asp?msg=19" set rsCheckDuplicates = mlConn.Execute("SELECT * FROM ML_Lists Where ListName = '" & ListName & "'") if NOT rsCheckDuplicates.EOF then response.redirect "message.asp?msg=8&list=" & Server.URLEncode(ListName) set rsCheckDuplicates = nothing ListDescription = Replace(Request("ListDescription"),"'","''") DoubleOptin = Replace(Request("DoubleOptin"),"'","''") DoubleOptout = Replace(Request("DoubleOptout"),"'","''") HeaderText = Replace(Request("HeaderText"),"'","''") HeaderHTML = Replace(Request("HeaderHTML"),"'","''") FooterText = Replace(Request("FooterText"),"'","''") FooterHTML = Replace(Request("FooterHTML"),"'","''") OptinMessage = Replace(Request("OptinMessage"),"'","''") OptoutMessage = Replace(Request("OptoutMessage"),"'","''") SubscribeSubject = Replace(Request("SubscribeSubject"),"'","''") SubscribeText = Replace(Request("SubscribeText"),"'","''") SubscribeHTML = Replace(Request("SubscribeHTML"),"'","''") UnsubscribeSubject = Replace(Request("UnsubscribeSubject"),"'","''") UnsubscribeText = Replace(Request("UnsubscribeText"),"'","''") UnsubscribeHTML = Replace(Request("UnsubscribeHTML"),"'","''") BCCListAdmin = Replace(Request("BCCListAdmin"),"'","''") PublicList = Replace(Request("PublicList"),"'","''") SWE = Replace(Request("SWE"),"'","''") SUE = Replace(Request("SUE"),"'","''") CreatedBy = Session("svUsername") LastEmailSent = Now strSQL = "INSERT INTO ML_Lists (ListName, ListDescription, DoubleOptin, DoubleOptout, HeaderText, HeaderHTML, FooterText, FooterHTML, OptinMessage, OptoutMessage, SubscribeSubject, SubscribeText, SubscribeHTML, UnsubscribeSubject, UnsubscribeText, UnsubscribeHTML, BCCListAdmin, PublicList, ListAdminEmail, SWE, SUE, CreatedDate, CreatedBy, LastEmailSentDate) VALUES ('" & ListName & "','" & ListDescription & "','" & DoubleOptin & "','" & DoubleOptout & "','" & HeaderText & "','" & HeaderHTML & "','" & FooterText & "','" & FooterHTML & "','" & OptinMessage & "','" & OptoutMessage & "','" & SubscribeSubject & "','" & SubscribeText & "','" & SubscribeHTML & "','" & UnsubscribeSubject & "','" & UnsubscribeText & "','" & UnsubscribeHTML & "','" & BCCListAdmin & "','" & PublicList & "','" & ListAdminEmail & "','" & SWE & "','" & SUE & "'," & cfgDate & ",'" & CreatedBy & "'," & cfgDate & ")" mlConn.Execute(strSQL) set rsGetListID = mlConn.Execute("SELECT * FROM ML_Lists Where ListName = '" & ListName & "' AND CreatedBy = '" & CreatedBy & "'") NewListID = rsGetListID("ListID") set rsGetListID = nothing response.redirect "message.asp?msg=9&list=" & Server.URLEncode(ListName) & "&ListID=" & NewListID end if %>
|
Create List |
||
|
|