%@LANGUAGE="VBSCRIPT"%>
<%'On Error Resume Next
If request("Submit") <> "" then
sFullname = request("sFullname")
sAddress = request("sAddress")
sCity = request("sCity")
sState = request("sState")
sZipcode = request("sZipcode")
sPhone = request("sPhone")
sEmail = request("sEmail")
Set insertCmd = Server.CreateObject("ADODB.Command")
insertCmd.ActiveConnection = globalConnectionString
insertStr = "INSERT INTO Members (m_name, m_address, m_city, m_state, m_zip, m_phone, m_email) VALUES ('" & sFullname & "','" & sAddress & "','" & sCity & "','" & sState & "','" & sZipcode & "','" & sPhone & "','" & sEmail & "');"
insertCmd.CommandText = insertStr
insertCmd.Execute
Set insertCmd = nothing
Dim objMail
Set objMail = CreateObject("CDONTS.NewMail")
if IsObject(objMail) Then
objMail.From = "NoReply@NonStopHunting.Net"
'objMail.To = "tonyb@vsginc.net"
objMail.To = sEmail
objMail.Subject = "NonStopHunting.Net Member Sign-up"
objMail.Body = "Thank you for signing up for our Member List."
objMail.Send
Set objMail = Nothing
End if
response.redirect("1biggestfan_form.asp")
End if
%>
Non Stop Hunting.NET