<% ' 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("Register1_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(29) Dim arFormDBFields0(29) Dim arFormValues0(29) arFormFields0(0) = "StreetAddress" arFormDBFields0(0) = "StreetAddress" arFormValues0(0) = Request("StreetAddress") arFormFields0(1) = "Sex" arFormDBFields0(1) = "Sex" arFormValues0(1) = Request("Sex") arFormFields0(2) = "Birthdate" arFormDBFields0(2) = "Birthdate" arFormValues0(2) = Request("Birthdate") arFormFields0(3) = "ParentPhoneNo" arFormDBFields0(3) = "ParentPhoneNo" arFormValues0(3) = Request("ParentPhoneNo") arFormFields0(4) = "HomeAreaCode" arFormDBFields0(4) = "HomeAreaCode" arFormValues0(4) = Request("HomeAreaCode") arFormFields0(5) = "StudentAge" arFormDBFields0(5) = "StudentAge" arFormValues0(5) = Request("StudentAge") arFormFields0(6) = "StudentEmail" arFormDBFields0(6) = "StudentEmail" arFormValues0(6) = Request("StudentEmail") arFormFields0(7) = "ParentLastName" arFormDBFields0(7) = "ParentLastName" arFormValues0(7) = Request("ParentLastName") arFormFields0(8) = "ParentWorkPhoneNo" arFormDBFields0(8) = "ParentWorkPhoneNo" arFormValues0(8) = Request("ParentWorkPhoneNo") arFormFields0(9) = "HomePhoneNo" arFormDBFields0(9) = "HomePhoneNo" arFormValues0(9) = Request("HomePhoneNo") arFormFields0(10) = "StudentYahooEmail" arFormDBFields0(10) = "StudentYahooEmail" arFormValues0(10) = Request("StudentYahooEmail") arFormFields0(11) = "ParentWorkAreaCode" arFormDBFields0(11) = "ParentWorkAreaCode" arFormValues0(11) = Request("ParentWorkAreaCode") arFormFields0(12) = "MiddleName" arFormDBFields0(12) = "MiddleName" arFormValues0(12) = Request("MiddleName") arFormFields0(13) = "HaveYahooEmail" arFormDBFields0(13) = "HaveYahooEmail" arFormValues0(13) = Request("HaveYahooEmail") arFormFields0(14) = "ParentFirstName" arFormDBFields0(14) = "ParentFirstName" arFormValues0(14) = Request("ParentFirstName") arFormFields0(15) = "WorkPhoneNo" arFormDBFields0(15) = "WorkPhoneNo" arFormValues0(15) = Request("WorkPhoneNo") arFormFields0(16) = "ParentCity" arFormDBFields0(16) = "ParentCity" arFormValues0(16) = Request("ParentCity") arFormFields0(17) = "ParentZip" arFormDBFields0(17) = "ParentZip" arFormValues0(17) = Request("ParentZip") arFormFields0(18) = "City" arFormDBFields0(18) = "City" arFormValues0(18) = Request("City") arFormFields0(19) = "WorkAreaCode" arFormDBFields0(19) = "WorkAreaCode" arFormValues0(19) = Request("WorkAreaCode") arFormFields0(20) = "ParentEmail" arFormDBFields0(20) = "ParentEmail" arFormValues0(20) = Request("ParentEmail") arFormFields0(21) = "FirstName" arFormDBFields0(21) = "FirstName" arFormValues0(21) = Request("FirstName") arFormFields0(22) = "TeacherName" arFormDBFields0(22) = "TeacherName" arFormValues0(22) = Request("TeacherName") arFormFields0(23) = "Zip" arFormDBFields0(23) = "Zip" arFormValues0(23) = Request("Zip") arFormFields0(24) = "ParentStreetAddress" arFormDBFields0(24) = "ParentStreetAddress" arFormValues0(24) = Request("ParentStreetAddress") arFormFields0(25) = "ParentHomeAreaCode" arFormDBFields0(25) = "ParentHomeAreaCode" arFormValues0(25) = Request("ParentHomeAreaCode") arFormFields0(26) = "LastName" arFormDBFields0(26) = "LastName" arFormValues0(26) = Request("LastName") arFormFields0(27) = "State" arFormDBFields0(27) = "State" arFormValues0(27) = Request("State") arFormFields0(28) = "ParentState" arFormDBFields0(28) = "ParentState" arFormValues0(28) = Request("ParentState") 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 FP_FormConfirmation "text/html; charset=windows-1252",_ "Form Confirmation",_ "Thank you for submitting the following information:",_ "Register.asp",_ "Return to the form." End If End If Session.CodePage = Session("FP_OldCodePage") Session.LCID = Session("FP_OldLCID") %> Register

Student Registration
Parent and Student, please fill in the following information.

Student Information
First Name Middle Name Last Name
Street Address City State Zip
 Home Phone Area Code Phone Number
 Work  Phone Area Code   Phone Number
Age 
 
Sex
 Birth date
 
(
use commas,
example: 12,05,80)
Main Email  
Teacher's Name Yahoo e-mail ( If not your main e-mail)
Do you have a Yahoo account?  If not, I'd like you to get one soon.
Parent Information (optional)
First Name Last Name  
 
(Parent address required, if different than Student address.)
Street Address City State Zip
Home Phone
(If different than Student's phone)
Area Code Phone Number
Work  Phone Area Code   Phone Number
Parent's main e-mail account

 

Press Submit when you have completed filling out the form.
Press Cancel if you have made and error and want o begin again.
If you have made an error and already pressed the Submit button,
you should fill the form and re-submit it.