<%@LANGUAGE="VBSCRIPT"%> <% Dim MM_editAction MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME")) If (Request.QueryString <> "") Then MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString) End If ' boolean to abort record edit Dim MM_abortEdit MM_abortEdit = false %> <% If (CStr(Request("MM_insert")) = "form1") Then If (Not MM_abortEdit) Then ' execute the insert Dim MM_editCmd Set MM_editCmd = Server.CreateObject ("ADODB.Command") MM_editCmd.ActiveConnection = MM_conn_STRING MM_editCmd.CommandText = "INSERT INTO Main (firstname, lastname, organization, streetaddress, email, city, phone, message) VALUES (?, ?, ?, ?, ?, ?, ?, ?)" MM_editCmd.Prepared = true MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 202, 1, 50, Request.Form("firstname")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 202, 1, 50, Request.Form("lastname")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 202, 1, 50, Request.Form("organization")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param4", 202, 1, 50, Request.Form("streetaddress")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param5", 202, 1, 50, Request.Form("email")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param6", 202, 1, 50, Request.Form("city")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param7", 202, 1, 50, Request.Form("phone")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param8", 202, 1, 255, Request.Form("message")) ' adVarWChar MM_editCmd.Execute MM_editCmd.ActiveConnection.Close ' append the query string to the redirect URL Dim MM_editRedirectUrl MM_editRedirectUrl = "/thankyou.htm" If (Request.QueryString <> "") Then If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0) Then MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString Else MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString End If End If Response.Redirect(MM_editRedirectUrl) End If End If %> <% Dim rsInfo Dim rsInfo_cmd Dim rsInfo_numRows Set rsInfo_cmd = Server.CreateObject ("ADODB.Command") rsInfo_cmd.ActiveConnection = MM_conn_STRING rsInfo_cmd.CommandText = "SELECT * FROM Main" rsInfo_cmd.Prepared = true Set rsInfo = rsInfo_cmd.Execute rsInfo_numRows = 0 %> <% Dim RSContact Dim RSContact_cmd Dim RSContact_numRows Set RSContact_cmd = Server.CreateObject ("ADODB.Command") RSContact_cmd.ActiveConnection = MM_conn_STRING RSContact_cmd.CommandText = "SELECT * FROM Main" RSContact_cmd.Prepared = true Set RSContact = RSContact_cmd.Execute RSContact_numRows = 0 %> High End PCS for High End PC Performance
 
For High End Performance
  
  
 
 
Contact Information

PCHELP.US.COM
770.595.6995
770.607.1654

simon@pchelp.us.com

 

 


 
 

 
 
 
 


PC HELP
Office: 770.607.1654
Cell: 770.595.6995
Email: simon@pchelp.us.com

     
             
<% rsInfo.Close() Set rsInfo = Nothing %> <% RSContact.Close() Set RSContact = Nothing %>