% ' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit. On Error Resume Next Session("FP_OldCodePage") = Session.CodePage Session("FP_OldLCID") = Session.LCID Session.CodePage = 1252 Session.LCID = 1033 Err.Clear strErrorUrl = "" If Request.ServerVariables("REQUEST_METHOD") = "POST" Then If Request.Form("VTI-GROUP") = "0" Then Err.Clear Set fp_conn = Server.CreateObject("ADODB.Connection") FP_DumpError strErrorUrl, "Cannot create connection" Set fp_rs = Server.CreateObject("ADODB.Recordset") FP_DumpError strErrorUrl, "Cannot create record set" fp_conn.Open Application("Design Secrets Form_ConnectionString") FP_DumpError strErrorUrl, "Cannot open database" fp_rs.Open "Results", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable FP_DumpError strErrorUrl, "Cannot open record set" fp_rs.AddNew FP_DumpError strErrorUrl, "Cannot add new record set to the database" Dim arFormFields0(20) Dim arFormDBFields0(20) Dim arFormValues0(20) arFormFields0(0) = "Contact_StreetAddress0" arFormDBFields0(0) = "Contact_StreetAddress0" arFormValues0(0) = Request("Contact_StreetAddress0") arFormFields0(1) = "Contact_ZipCode0" arFormDBFields0(1) = "Contact_ZipCode0" arFormValues0(1) = Request("Contact_ZipCode0") arFormFields0(2) = "Contact_HomePhone" arFormDBFields0(2) = "Contact_HomePhone" arFormValues0(2) = Request("Contact_HomePhone") arFormFields0(3) = "Contact_Address3" arFormDBFields0(3) = "Contact_Address3" arFormValues0(3) = Request("Contact_Address3") arFormFields0(4) = "Services_Updo" arFormDBFields0(4) = "Services_Updo" arFormValues0(4) = Request("Services_Updo") arFormFields0(5) = "Contact_City0" arFormDBFields0(5) = "Contact_City0" arFormValues0(5) = Request("Contact_City0") arFormFields0(6) = "Contact_State0" arFormDBFields0(6) = "Contact_State0" arFormValues0(6) = Request("Contact_State0") arFormFields0(7) = "Services_Weave" arFormDBFields0(7) = "Services_Weave" arFormValues0(7) = Request("Services_Weave") arFormFields0(8) = "Services_Color" arFormDBFields0(8) = "Services_Color" arFormValues0(8) = Request("Services_Color") arFormFields0(9) = "Contact_FirstName" arFormDBFields0(9) = "Contact_FirstName" arFormValues0(9) = Request("Contact_FirstName") arFormFields0(10) = "Services_Braids" arFormDBFields0(10) = "Services_Braids" arFormValues0(10) = Request("Services_Braids") arFormFields0(11) = "Contact_Email0" arFormDBFields0(11) = "Contact_Email0" arFormValues0(11) = Request("Contact_Email0") arFormFields0(12) = "additional info" arFormDBFields0(12) = "additional_info" arFormValues0(12) = Request("additional info") arFormFields0(13) = "Contact_Country0" arFormDBFields0(13) = "Contact_Country0" arFormValues0(13) = Request("Contact_Country0") arFormFields0(14) = "Time" arFormDBFields0(14) = "Time" arFormValues0(14) = Request("Time") arFormFields0(15) = "Contact_LastName" arFormDBFields0(15) = "Contact_LastName" arFormValues0(15) = Request("Contact_LastName") arFormFields0(16) = "Services_Cut" arFormDBFields0(16) = "Services_Cut" arFormValues0(16) = Request("Services_Cut") arFormFields0(17) = "Date" arFormDBFields0(17) = "Date" arFormValues0(17) = Request("Date") arFormFields0(18) = "Services_Perm" arFormDBFields0(18) = "Services_Perm" arFormValues0(18) = Request("Services_Perm") arFormFields0(19) = "Location" arFormDBFields0(19) = "Location" arFormValues0(19) = Request("Location") FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0 If Request.ServerVariables("REMOTE_HOST") <> "" Then FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_HOST"), "Remote_computer_name" End If If Request.ServerVariables("HTTP_USER_AGENT") <> "" Then FP_SaveFieldToDB fp_rs, Request.ServerVariables("HTTP_USER_AGENT"), "Browser_type" End If FP_SaveFieldToDB fp_rs, Now, "Timestamp" If Request.ServerVariables("REMOTE_USER") <> "" Then FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_USER"), "User_name" End If fp_rs.Update FP_DumpError strErrorUrl, "Cannot update the database" fp_rs.Close fp_conn.Close Session("FP_SavedFields")=arFormFields0 Session("FP_SavedValues")=arFormValues0 Session.CodePage = Session("FP_OldCodePage") Session.LCID = Session("FP_OldLCID") Response.Redirect "Design Secrets Confirmation Page.asp" End If End If Session.CodePage = Session("FP_OldCodePage") Session.LCID = Session("FP_OldLCID") %>
All Rights Reserved. No part of this site may be copied without permission. HGA web designs, Copyright 2008 Photos are not the property of Design Secrets. All Photos are by unknown photographers and unknown stylist |