%@ LANGUAGE="VBSCRIPT" %>
<%
If Request.Form("Submission")="True" Then
' *** Save submission information ***
Set ConnActivityResponse = Server.CreateObject("ADODB.Connection")
Set CmdAddActivityResponse = Server.CreateObject("ADODB.Recordset")
ConnActivityResponse.Open strConnect
SQL = "SELECT * FROM activity_responses"
CmdAddActivityResponse.Open SQL, ConnActivityResponse, 1, 3
CmdAddActivityResponse.AddNew
CmdAddActivityResponse.Fields("full_name")=Left(Request.Form("full_name"),255)
CmdAddActivityResponse.Fields("position")=Left(Request.Form("position"),100)
CmdAddActivityResponse.Fields("university_college")=Left(Request.Form("university_college"),100)
CmdAddActivityResponse.Fields("phone")=Left(Request.Form("phone"),20)
CmdAddActivityResponse.Fields("fax")=Left(Request.Form("fax"),20)
CmdAddActivityResponse.Fields("email")=Left(Request.Form("email"),100)
CmdAddActivityResponse.Fields("activity_description")=Request.Form("activity_description")
CmdAddActivityResponse.Fields("activity_where_when")=Request.Form("activity_where_when")
CmdAddActivityResponse.Fields("activity_evaluation")=Request.Form("activity_evaluation")
CmdAddActivityResponse.Fields("activity_resources")=Request.Form("activity_resources")
CmdAddActivityResponse.Fields("submission_time")=now()
CmdAddActivityResponse.Update
' *** Release objects ***
CmdAddActivityResponse.Close
Set CmdAddActivityResponse= Nothing
ConnActivityResponse.Close
Set ConnActivityResponse = Nothing
'*** Send Action Plan to Shane ***
Set Mail = Server.CreateObject("Persits.MailSender")
Mail.Host = "mail.acuiweb.org"
Mail.IsHTML = True
Mail.From = "info@stophate.org"
Mail.FromName = "info@stophate.org"
Mail.AddAddress "info@stophate.org"
Mail.Subject = "stopehate.org Response Activity Form Submission"
Mail.Body = "A new Response Activity Form received!" & _
"Full Name: " & Request.Form("full_name") & "
" & _
"Position or Job Title: " & Request.Form("position") & "
" & _
"College/University: " & Request.Form("university_college") & "
" & _
"Telephone Number: " & Request.Form("phone") & "
" & _
"Fax Number: " & Request.Form("fax") & "
" & _
"Email Address: " & Request.Form("email") & "
" & _
"Activity Description: " & Request.Form("activity_description") & "
" & _
"Activity Where & When: " & Request.Form("activity_where_when") & "
" & _
"Activity Evaluation: " & Request.Form("activity_evaluation") & "
" & _
"Activity Resources: " & Request.Form("activity_resources") & "
"
On Error Resume Next
Mail.Send
'*** Send Action Plan to Submitter ***
Set Mail = Server.CreateObject("Persits.MailSender")
Mail.Host = "mail.acuiweb.org"
Mail.IsHTML = True
Mail.From = "info@stophate.org"
Mail.FromName = "info@stophate.org"
Mail.AddAddress Request.Form("email")
Mail.Subject = "stopehate.org Response Activity Form Submission"
Mail.Body = "Thank You for your submission!" & _
"Full Name: " & Request.Form("full_name") & "
" & _
"Position or Job Title: " & Request.Form("position") & "
" & _
"College/University: " & Request.Form("university_college") & "
" & _
"Telephone Number: " & Request.Form("phone") & "
" & _
"Fax Number: " & Request.Form("fax") & "
" & _
"Email Address: " & Request.Form("email") & "
" & _
"Activity Description: " & Request.Form("activity_description") & "
" & _
"Activity Where & When: " & Request.Form("activity_where_when") & "
" & _
"Activity Evaluation: " & Request.Form("activity_evaluation") & "
" & _
"Activity Resources: " & Request.Form("activity_resources") & "
"
On Error Resume Next
Mail.Send
Response.Redirect "responseactivityform_thankyou.asp"
End If
%>
STOP THE HATE! Train the Trainer Response Activity Form