home *** CD-ROM | disk | FTP | other *** search
/ bombers.k12.ar.us / bombers.k12.ar.us.tar / bombers.k12.ar.us / testing.asp < prev    next >
Text File  |  2005-10-14  |  16KB  |  321 lines
  1. <%
  2. ' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit.
  3. On Error Resume Next
  4.  
  5. strErrorUrl = "error.htm"
  6.  
  7. If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
  8. If Request.Form("VTI-GROUP") = "0" Then
  9.     Err.Clear
  10.  
  11.     Set fp_conn =  Server.CreateObject("ADODB.Connection")
  12.     FP_DumpError strErrorUrl, "Cannot create connection"
  13.  
  14.     Set fp_rs = Server.CreateObject("ADODB.Recordset")
  15.     FP_DumpError strErrorUrl, "Cannot create record set"
  16.  
  17.     fp_conn.Open Application("testing_ConnectionString")
  18.     FP_DumpError strErrorUrl, "Cannot open database"
  19.  
  20.     fp_rs.Open "Results", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable
  21.     FP_DumpError strErrorUrl, "Cannot open record set"
  22.  
  23.     fp_rs.AddNew
  24.     FP_DumpError strErrorUrl, "Cannot add new record set to the database"
  25.     Dim arFormFields0(40)
  26.     Dim arFormDBFields0(40)
  27.     Dim arFormValues0(40)
  28.  
  29.     arFormFields0(0) = "RefPhone2"
  30.     arFormDBFields0(0) = "RefPhone2"
  31.     arFormValues0(0) = Request("RefPhone2")
  32.     arFormFields0(1) = "HighSchool"
  33.     arFormDBFields0(1) = "HighSchool"
  34.     arFormValues0(1) = Request("HighSchool")
  35.     arFormFields0(2) = "Telephone"
  36.     arFormDBFields0(2) = "Telephone"
  37.     arFormValues0(2) = Request("Telephone")
  38.     arFormFields0(3) = "RefPhone3"
  39.     arFormDBFields0(3) = "RefPhone3"
  40.     arFormValues0(3) = Request("RefPhone3")
  41.     arFormFields0(4) = "SalCur"
  42.     arFormDBFields0(4) = "SalCur"
  43.     arFormValues0(4) = Request("SalCur")
  44.     arFormFields0(5) = "WESup1"
  45.     arFormDBFields0(5) = "WESup1"
  46.     arFormValues0(5) = Request("WESup1")
  47.     arFormFields0(6) = "SocSecNum"
  48.     arFormDBFields0(6) = "SocSecNum"
  49.     arFormValues0(6) = Request("SocSecNum")
  50.     arFormFields0(7) = "WESup2"
  51.     arFormDBFields0(7) = "WESup2"
  52.     arFormValues0(7) = Request("WESup2")
  53.     arFormFields0(8) = "MiddleName"
  54.     arFormDBFields0(8) = "MiddleName"
  55.     arFormValues0(8) = Request("MiddleName")
  56.     arFormFields0(9) = "WESup3"
  57.     arFormDBFields0(9) = "WESup3"
  58.     arFormValues0(9) = Request("WESup3")
  59.     arFormFields0(10) = "WECo1"
  60.     arFormDBFields0(10) = "WECo1"
  61.     arFormValues0(10) = Request("WECo1")
  62.     arFormFields0(11) = "WECo2"
  63.     arFormDBFields0(11) = "WECo2"
  64.     arFormValues0(11) = Request("WECo2")
  65.     arFormFields0(12) = "RefAdd1"
  66.     arFormDBFields0(12) = "RefAdd1"
  67.     arFormValues0(12) = Request("RefAdd1")
  68.     arFormFields0(13) = "WECo3"
  69.     arFormDBFields0(13) = "WECo3"
  70.     arFormValues0(13) = Request("WECo3")
  71.     arFormFields0(14) = "RefAdd2"
  72.     arFormDBFields0(14) = "RefAdd2"
  73.     arFormValues0(14) = Request("RefAdd2")
  74.     arFormFields0(15) = "SalEx"
  75.     arFormDBFields0(15) = "SalEx"
  76.     arFormValues0(15) = Request("SalEx")
  77.     arFormFields0(16) = "College1"
  78.     arFormDBFields0(16) = "College1"
  79.     arFormValues0(16) = Request("College1")
  80.     arFormFields0(17) = "Email"
  81.     arFormDBFields0(17) = "Email"
  82.     arFormValues0(17) = Request("Email")
  83.     arFormFields0(18) = "City"
  84.     arFormDBFields0(18) = "City"
  85.     arFormValues0(18) = Request("City")
  86.     arFormFields0(19) = "RefAdd3"
  87.     arFormDBFields0(19) = "RefAdd3"
  88.     arFormValues0(19) = Request("RefAdd3")
  89.     arFormFields0(20) = "WEDate1"
  90.     arFormDBFields0(20) = "WEDate1"
  91.     arFormValues0(20) = Request("WEDate1")
  92.     arFormFields0(21) = "AreaTrain1"
  93.     arFormDBFields0(21) = "AreaTrain1"
  94.     arFormValues0(21) = Request("AreaTrain1")
  95.     arFormFields0(22) = "Degree"
  96.     arFormDBFields0(22) = "Degree"
  97.     arFormValues0(22) = Request("Degree")
  98.     arFormFields0(23) = "College2"
  99.     arFormDBFields0(23) = "College2"
  100.     arFormValues0(23) = Request("College2")
  101.     arFormFields0(24) = "WEDate2"
  102.     arFormDBFields0(24) = "WEDate2"
  103.     arFormValues0(24) = Request("WEDate2")
  104.     arFormFields0(25) = "AreaTrain2"
  105.     arFormDBFields0(25) = "AreaTrain2"
  106.     arFormValues0(25) = Request("AreaTrain2")
  107.     arFormFields0(26) = "Hours"
  108.     arFormDBFields0(26) = "Hours"
  109.     arFormValues0(26) = Request("Hours")
  110.     arFormFields0(27) = "FirstName"
  111.     arFormDBFields0(27) = "FirstName"
  112.     arFormValues0(27) = Request("FirstName")
  113.     arFormFields0(28) = "Other"
  114.     arFormDBFields0(28) = "Other"
  115.     arFormValues0(28) = Request("Other")
  116.     arFormFields0(29) = "RefName1"
  117.     arFormDBFields0(29) = "RefName1"
  118.     arFormValues0(29) = Request("RefName1")
  119.     arFormFields0(30) = "WEDate3"
  120.     arFormDBFields0(30) = "WEDate3"
  121.     arFormValues0(30) = Request("WEDate3")
  122.     arFormFields0(31) = "AreaTrain3"
  123.     arFormDBFields0(31) = "AreaTrain3"
  124.     arFormValues0(31) = Request("AreaTrain3")
  125.     arFormFields0(32) = "Zip"
  126.     arFormDBFields0(32) = "Zip"
  127.     arFormValues0(32) = Request("Zip")
  128.     arFormFields0(33) = "RefName2"
  129.     arFormDBFields0(33) = "RefName2"
  130.     arFormValues0(33) = Request("RefName2")
  131.     arFormFields0(34) = "RefName3"
  132.     arFormDBFields0(34) = "RefName3"
  133.     arFormValues0(34) = Request("RefName3")
  134.     arFormFields0(35) = "LastName"
  135.     arFormDBFields0(35) = "LastName"
  136.     arFormValues0(35) = Request("LastName")
  137.     arFormFields0(36) = "State"
  138.     arFormDBFields0(36) = "State"
  139.     arFormValues0(36) = Request("State")
  140.     arFormFields0(37) = "PosDes"
  141.     arFormDBFields0(37) = "PosDes"
  142.     arFormValues0(37) = Request("PosDes")
  143.     arFormFields0(38) = "RefPhone1"
  144.     arFormDBFields0(38) = "RefPhone1"
  145.     arFormValues0(38) = Request("RefPhone1")
  146.     arFormFields0(39) = "PresAddr"
  147.     arFormDBFields0(39) = "PresAddr"
  148.     arFormValues0(39) = Request("PresAddr")
  149.  
  150.     FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0
  151.  
  152.     If Request.ServerVariables("HTTP_USER_AGENT") <> "" Then
  153.         FP_SaveFieldToDB fp_rs, Request.ServerVariables("HTTP_USER_AGENT"), "Browser_type"
  154.     End If
  155.     If Request.ServerVariables("REMOTE_HOST") <> "" Then
  156.         FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_HOST"), "Remote_computer_name"
  157.     End If
  158.     FP_SaveFieldToDB fp_rs, Now, "Timestamp"
  159.     If Request.ServerVariables("REMOTE_USER") <> "" Then
  160.         FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_USER"), "User_name"
  161.     End If
  162.  
  163.     fp_rs.Update
  164.     FP_DumpError strErrorUrl, "Cannot update the database"
  165.  
  166.     fp_rs.Close
  167.     fp_conn.Close
  168.  
  169.     Session("FP_SavedFields")=arFormFields0
  170.     Session("FP_SavedValues")=arFormValues0
  171.     Response.Redirect "confirmation.htm"
  172.  
  173. End If
  174. End If
  175.  
  176. %>
  177. <html>
  178.  
  179. <head>
  180. <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
  181. <meta name="GENERATOR" content="Microsoft FrontPage 4.0">
  182. <meta name="ProgId" content="FrontPage.Editor.Document">
  183. <title>Employment Application for Classified Employees</title>
  184. </head>
  185.  
  186. <body>
  187.  
  188. <form method="POST" action="testing.asp" webbot-action="--WEBBOT-SELF--">
  189.   <!--webbot bot="SaveDatabase" SuggestedExt="asp"
  190.   U-ASP-Include-Url="_fpclass/fpdbform.inc" S-DataConnection="testing"
  191.   S-RecordSource="Results" U-Database-URL="fpdb/testing.mdb"
  192.   U-Confirmation-Url="confirmation.htm" U-Validation-Error-Url="error.htm"
  193.   S-Builtin-Fields="HTTP_USER_AGENT REMOTE_HOST Timestamp REMOTE_USER"
  194.   S-Builtin-DBFields="Browser_type Remote_computer_name Timestamp User_name"
  195.   S-Form-Fields="RefPhone2 HighSchool Telephone RefPhone3 SalCur WESup1 SocSecNum WESup2 MiddleName WESup3 WECo1 WECo2 RefAdd1 WECo3 RefAdd2 SalEx College1 Email City RefAdd3 WEDate1 AreaTrain1 Degree College2 WEDate2 AreaTrain2 Hours FirstName Other RefName1 WEDate3 AreaTrain3 Zip RefName2 RefName3 LastName State PosDes RefPhone1 PresAddr"
  196.   S-Form-DBFields="RefPhone2 HighSchool Telephone RefPhone3 SalCur WESup1 SocSecNum WESup2 MiddleName WESup3 WECo1 WECo2 RefAdd1 WECo3 RefAdd2 SalEx College1 Email City RefAdd3 WEDate1 AreaTrain1 Degree College2 WEDate2 AreaTrain2 Hours FirstName Other RefName1 WEDate3 AreaTrain3 Zip RefName2 RefName3 LastName State PosDes RefPhone1 PresAddr" startspan
  197.   --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include file="_fpclass/fpdbform.inc"--><!--webbot bot="SaveDatabase" endspan i-checksum="40548"
  198.   -->
  199.   <p align="center" style="margin-top: 0; margin-bottom: 10"><b>Employment
  200.   Application for Classified Employees</b></p>
  201.   <hr>
  202.   <p style="margin-top: 1; margin-bottom: 1" align="center"><b>Contact
  203.   Information</b></p>
  204.   <p style="margin-top: 1; margin-bottom: 1">Position Desired: <input name="PosDes" size="60">          
  205.   </p>
  206.   <p style="margin-top: 1; margin-bottom: 1">       
  207.   Last Name: <input name="LastName" size="20">      
  208.   First Name: <input name="FirstName" size="24">       </p>
  209.   <p style="margin-top: 1; margin-bottom: 1">    Middle Name: <input name="MiddleName" size="20">   
  210.   Social Security Number: <input name="SocSecNum" size="15"></p>
  211.   <p style="margin-top: 1; margin-bottom: 1">Current Address: <input name="PresAddr" size="40"></p>
  212.   <p style="margin-top: 1; margin-bottom: 1">        
  213.   City: <input name="City" size="25"> State:  <select size="1" name="State">
  214.     <option value="AL">Alabama</option>
  215.     <option value="AK">Alaska</option>
  216.     <option value="AZ">Arizona</option>
  217.     <option selected value="AR">Arkansas</option>
  218.     <option value="CA">California</option>
  219.     <option value="CO">Colorado</option>
  220.     <option value="CT">Connecticut</option>
  221.     <option value="DE">Delaware</option>
  222.     <option value="DC">District of Columbia</option>
  223.     <option value="FL">Florida</option>
  224.     <option value="GA">Georgia</option>
  225.     <option value="HI">Hawaii</option>
  226.     <option value="ID">Idaho</option>
  227.     <option value="IL">Illinois</option>
  228.     <option value="IN">Indiana</option>
  229.     <option value="IA">Iowa</option>
  230.     <option value="KS">Kansas</option>
  231.     <option value="KY">Kentucky</option>
  232.     <option value="LA">Louisiana</option>
  233.     <option value="ME">Maine</option>
  234.     <option value="MD">Maryland</option>
  235.     <option value="MA">Massachusetts</option>
  236.     <option value="MI">Michigan</option>
  237.     <option value="MN">Minnesota</option>
  238.     <option value="MS">Mississippi</option>
  239.     <option value="MO">Missouri</option>
  240.     <option value="MT">Montana</option>
  241.     <option value="NE">Nebraska</option>
  242.     <option value="NV">Nevada</option>
  243.     <option value="NH">New Hampshire</option>
  244.     <option value="NJ">New Jersey</option>
  245.     <option value="NM">New Mexico</option>
  246.     <option value="NY">New York</option>
  247.     <option value="NC">North Carolina</option>
  248.     <option value="ND">North Dakota</option>
  249.     <option value="OH">Ohio</option>
  250.     <option value="OK">Oklahoma</option>
  251.     <option value="OR">Oregon</option>
  252.     <option value="PA">Pennsylvania</option>
  253.     <option value="PR">Puerto Rico</option>
  254.     <option value="RI">Rhode Island</option>
  255.     <option value="SC">South Carolina</option>
  256.     <option value="SD">South Dakota</option>
  257.     <option value="TN">Tennessee</option>
  258.     <option value="TX">Texas</option>
  259.     <option value="UT">Utah</option>
  260.     <option value="VT">Vermont</option>
  261.     <option value="VA">Virginia</option>
  262.     <option value="WA">Washington</option>
  263.     <option value="WV">West Virginia</option>
  264.     <option value="WI">Wisconsin</option>
  265.     <option value="WY">Wyoming</option>
  266.   </select> Zip: <input name="Zip" size="15"></p>
  267.   <p style="margin-top: 1; margin-bottom: 1">Telephone: <input name="Telephone" size="19">           
  268.   Email Address: <input name="Email" size="31"></p>
  269.   <hr>
  270.   <p style="MARGIN-BOTTOM: 10px; MARGIN-TOP: 10px" align="center"><b>Educational
  271.   Background</b></p>
  272.   <p style="margin-top: 0; margin-bottom: 0">High School attended: <input name="HighSchool" size="60"></p>
  273.   <p style="margin-top: 0; margin-bottom: 0">      
  274.   College attended: <input name="College1" size="60"></p>
  275.   <p style="margin-top: 0; margin-bottom: 0">                                 
  276.   <input name="College2" size="60"></p>
  277.   <p style="margin-top: 0; margin-bottom: 0">                      
  278.   Degree<input name="Degree" size="15">or Number of Hours<input name="Hours" size="15"></p>
  279.   <p style="MARGIN-BOTTOM: 10px; MARGIN-TOP: 10px"> </p>
  280.   <p style="margin-top: 0; margin-bottom: 0">    Area(s) of
  281.   Training: <input name="AreaTrain1" size="50"></p>
  282.   <p style="margin-top: 0; margin-bottom: 0">                                 
  283.   <input name="AreaTrain2" size="50"></p>
  284.   <p style="margin-top: 0; margin-bottom: 0">                                 
  285.   <input name="AreaTrain3" size="50"></p>
  286.   <hr>
  287.   <p style="margin-top: 0; margin-bottom: 0" align="center"><b>Work Experience</b>
  288.   (Please list last employer first)</p>
  289.   <p style="margin-top: 0; margin-bottom: 0">               
  290.   Company and address            Dates
  291.   Worked                   
  292.   Supervisor</p>
  293.   <p style="margin-top: 0; margin-bottom: 0"><input name="WECo1" size="30"><input name="WEDate1" size="20"><input name="WESup1" size="29"></p>
  294.   <p style="margin-top: 0; margin-bottom: 0"><input name="WECo2" size="30"><input name="WEDate2" size="20"><input name="WESup2" size="29"></p>
  295.   <p style="margin-top: 0; margin-bottom: 0"><input name="WECo3" size="30"><input name="WEDate3" size="20"><input name="WESup3" size="29"></p>
  296.   <p style="margin-top: 0; margin-bottom: 0">    Current Salary<input name="SalCur" size="15">       
  297.   Expected Salary<input name="SalEx" size="20"></p>
  298.   <p style="margin-top: 0; margin-bottom: 0"> </p>
  299.   <hr>
  300.   <p style="margin-top: 0; margin-bottom: 0" align="center"><b>References</b>
  301.   (do not include relatives)</p>
  302.   <p style="margin-top: 0; margin-bottom: 0">               
  303.   Name                                       
  304.   Address                                 Telephone</p>
  305.   <p style="margin-top: 0; margin-bottom: 0"><input name="RefName1" size="29"><input name="RefAdd1" size="33"><input name="RefPhone1" size="20"></p>
  306.   <p style="margin-top: 0; margin-bottom: 0"><input name="RefName2" size="29"><input name="RefAdd2" size="33"><input name="RefPhone2" size="20"></p>
  307.   <p style="margin-top: 0; margin-bottom: 0"><input name="RefName3" size="29"><input name="RefAdd3" size="33"><input name="RefPhone3" size="20"></p>
  308.   <p style="MARGIN-BOTTOM: 10px; MARGIN-TOP: 10px">Other relevant information</p>
  309.   <p style="MARGIN-BOTTOM: 10px; MARGIN-TOP: 10px"><textarea cols="51" name="Other" rows="5"></textarea></p>
  310.   <p style="MARGIN-BOTTOM: 0px; MARGIN-TOP: 0px">The Mountain Home School
  311.   District is an Equal Opportunity Employer.  All applicants are considered
  312.   without regard to sex, race, color, creed, national origin or physical
  313.   handicap.</p>
  314.   <p style="MARGIN-BOTTOM: 0px; MARGIN-TOP: 0px"> </p>
  315.   <p style="MARGIN-BOTTOM: 0px; MARGIN-TOP: 0px" align="center"><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
  316. </form>
  317.  
  318. </body>
  319.  
  320. </html>
  321.