<% ' 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 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("playerInfo_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(36) Dim arFormDBFields0(36) Dim arFormValues0(36) arFormFields0(0) = "emailAddress" arFormDBFields0(0) = "emailAddress" arFormValues0(0) = Request("emailAddress") arFormFields0(1) = "FirstName" arFormDBFields0(1) = "FirstName" arFormValues0(1) = Request("FirstName") arFormFields0(2) = "PlayerStatus" arFormDBFields0(2) = "PlayerStatus" arFormValues0(2) = Request("PlayerStatus") arFormFields0(3) = "LastName" arFormDBFields0(3) = "LastName" arFormValues0(3) = Request("LastName") arFormFields0(4) = "NickName" arFormDBFields0(4) = "NickName" arFormValues0(4) = Request("NickName") arFormFields0(5) = "Occupation" arFormDBFields0(5) = "Occupation" arFormValues0(5) = Request("Occupation") arFormFields0(6) = "College" arFormDBFields0(6) = "College" arFormValues0(6) = Request("College") arFormFields0(7) = "HomePhone" arFormDBFields0(7) = "HomePhone" arFormValues0(7) = Request("HomePhone") arFormFields0(8) = "YearGraduated" arFormDBFields0(8) = "YearGraduated" arFormValues0(8) = Request("YearGraduated") arFormFields0(9) = "WorkPhone" arFormDBFields0(9) = "WorkPhone" arFormValues0(9) = Request("WorkPhone") arFormFields0(10) = "DDCountryBorn" arFormDBFields0(10) = "DDCountryBorn" arFormValues0(10) = Request("DDCountryBorn") arFormFields0(11) = "CellPhone" arFormDBFields0(11) = "CellPhone" arFormValues0(11) = Request("CellPhone") arFormFields0(12) = "YearsPlayed" arFormDBFields0(12) = "YearsPlayed" arFormValues0(12) = Request("YearsPlayed") arFormFields0(13) = "Address1" arFormDBFields0(13) = "Address1" arFormValues0(13) = Request("Address1") arFormFields0(14) = "NbrYearsPlayedIrish" arFormDBFields0(14) = "NbrYearsPlayedIrish" arFormValues0(14) = Request("NbrYearsPlayedIrish") arFormFields0(15) = "Address2" arFormDBFields0(15) = "Address2" arFormValues0(15) = Request("Address2") arFormFields0(16) = "CkProp" arFormDBFields0(16) = "CkProp" arFormValues0(16) = Request("CkProp") arFormFields0(17) = "City" arFormDBFields0(17) = "City" arFormValues0(17) = Request("City") arFormFields0(18) = "CkHooker" arFormDBFields0(18) = "CkHooker" arFormValues0(18) = Request("CkHooker") arFormFields0(19) = "DDState" arFormDBFields0(19) = "DDState" arFormValues0(19) = Request("DDState") arFormFields0(20) = "CkLock" arFormDBFields0(20) = "CkLock" arFormValues0(20) = Request("CkLock") arFormFields0(21) = "StateOther" arFormDBFields0(21) = "StateOther" arFormValues0(21) = Request("StateOther") arFormFields0(22) = "CkFlanker" arFormDBFields0(22) = "CkFlanker" arFormValues0(22) = Request("CkFlanker") arFormFields0(23) = "DDCountry" arFormDBFields0(23) = "DDCountry" arFormValues0(23) = Request("DDCountry") arFormFields0(24) = "Ck8Man" arFormDBFields0(24) = "Ck8Man" arFormValues0(24) = Request("Ck8Man") arFormFields0(25) = "ZipCode" arFormDBFields0(25) = "ZipCode" arFormValues0(25) = Request("ZipCode") arFormFields0(26) = "CkScrumHalf" arFormDBFields0(26) = "CkScrumHalf" arFormValues0(26) = Request("CkScrumHalf") arFormFields0(27) = "SubZipCode" arFormDBFields0(27) = "SubZipCode" arFormValues0(27) = Request("SubZipCode") arFormFields0(28) = "CkFlyHalf" arFormDBFields0(28) = "CkFlyHalf" arFormValues0(28) = Request("CkFlyHalf") arFormFields0(29) = "CkCenter" arFormDBFields0(29) = "CkCenter" arFormValues0(29) = Request("CkCenter") arFormFields0(30) = "CkWing" arFormDBFields0(30) = "CkWing" arFormValues0(30) = Request("CkWing") arFormFields0(31) = "CkFullBack" arFormDBFields0(31) = "CkFullBack" arFormValues0(31) = Request("CkFullBack") arFormFields0(32) = "Remote_computer_name" arFormDBFields0(32) = "Remote_computer_name" arFormValues0(32) = Request("Remote_computer_name") arFormFields0(33) = "User_name" arFormDBFields0(33) = "User_name" arFormValues0(33) = Request("User_name") arFormFields0(34) = "Browser_type" arFormDBFields0(34) = "Browser_type" arFormValues0(34) = Request("Browser_type") arFormFields0(35) = "Timestamp" arFormDBFields0(35) = "Timestamp" arFormValues0(35) = Request("Timestamp") FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0 fp_rs.Update FP_DumpError strErrorUrl, "Cannot update the database" fp_rs.Close fp_conn.Close FP_FormConfirmationFromArrays "text/html; charset=windows-1252",_ "Form Confirmation",_ "Thank you for submitting the following information:",_ "submission_formORIG.asp",_ "Return to the form.",_ arFormDBFields0,_ arFormValues0 End If End If Session.CodePage = Session("FP_OldCodePage") Session.LCID = Session("FP_OldLCID") %> <% If Session(SiteID) <> true Then Response.Redirect("Login.asp?requester=submission_form.asp") End If %> <% Response.Buffer = True %> Results -- New
Submission Form
Results Page | Submission Form | Database Editor



emailAddress
 

FirstName
 

PlayerStatus
 

LastName
 

NickName
 

Occupation
 

College
 

HomePhone
 

YearGraduated
 

WorkPhone
 

DDCountryBorn
 

CellPhone
 

YearsPlayed
 

Address1
 

NbrYearsPlayedIrish
 

Address2
 

CkProp
 

City
 

CkHooker
 

DDState
 

CkLock
 

StateOther
 

CkFlanker
 

DDCountry
 

Ck8Man
 

ZipCode
 

CkScrumHalf
 

SubZipCode
 

CkFlyHalf
 

CkCenter
 

CkWing
 

CkFullBack
 

Remote_computer_name
 

User_name
 

Browser_type
 

Timestamp