home *** CD-ROM | disk | FTP | other *** search
/ bombers.k12.ar.us / bombers.k12.ar.us.tar / bombers.k12.ar.us / Alumni / search_year_old.asp < prev    next >
Text File  |  2014-02-12  |  12KB  |  144 lines
  1. <html>
  2.  
  3. <head>
  4. <meta http-equiv="Content-Language" content="en-us">
  5. <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
  6. <meta name="GENERATOR" content="Microsoft FrontPage 4.0">
  7. <meta name="ProgId" content="FrontPage.Editor.Document">
  8. <title>Search by Year</title>
  9. </head>
  10.  
  11. <body>
  12.  
  13. <p align="center"><b>Search by </b><b>Year</b></p>
  14. <form BOTID="0" METHOD="POST" ACTION="search_year.asp">
  15.   <table BORDER="0">
  16.     <tr>
  17.       <td><b>GradYear</b></td>
  18.       <td><input TYPE="TEXT" NAME="GradYear" VALUE="<%=Request("GradYear")%>" size="20"></td>
  19.     </tr>
  20.   </table>
  21.   <br>
  22.   <input TYPE="Submit"><input TYPE="Reset"><!--webbot bot="SaveAsASP" CLIENTSIDE
  23.   SuggestedExt="asp" PREVIEW=" " -->
  24.   <p> </p>
  25. </form>
  26. <!--webbot bot="DatabaseRegionStart" startspan
  27. s-columnnames="ID,GradYear,LastName,FirstName,MaidenName,Email,Address,City,State,Zip,Comments,Remote_computer_name,User_name,Browser_type,Timestamp,Telephone,Salutation"
  28. s-columntypes="3,202,202,202,202,202,202,202,202,202,203,202,202,202,135,202,202"
  29. s-dataconnection="alumni1" b-tableformat="FALSE" b-menuformat="FALSE"
  30. s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE"
  31. b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-ListFormat="0"
  32. b-makeform="TRUE" s-recordsource="Alumni"
  33. s-displaycolumns="GradYear,LastName,FirstName,MaidenName,Email,Address,City,State,Zip,Comments,Salutation"
  34. s-criteria="[GradYear] EQ {GradYear} +" s-order="[LastName] +"
  35. s-sql="SELECT * FROM Alumni WHERE (GradYear =  '::GradYear::') ORDER BY LastName ASC"
  36. b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields="GradYear="
  37. s-NoRecordsFound="No records returned." i-MaxRecords="0" i-GroupSize="25"
  38. BOTID="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
  39. u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="BODY"
  40. local_preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">Database Results regions will not preview unless this page is fetched from a Web server using a web browser. The section of the page from here to the end of the Database Results region will repeat once for each record returned by the query.</font></td></tr></table>"
  41. preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the start of a Database Results region.</font></td></tr></table>" --><!--#include file="_fpclass/fpdblib.inc"-->
  42. <%
  43. fp_sQry="SELECT * FROM Alumni WHERE (GradYear =  '::GradYear::') ORDER BY LastName ASC"
  44. fp_sDefault="GradYear="
  45. fp_sNoRecords="No records returned."
  46. fp_sDataConn="alumni1"
  47. fp_iMaxRecords=0
  48. fp_iCommandType=1
  49. fp_iPageSize=25
  50. fp_fTableFormat=False
  51. fp_fMenuFormat=False
  52. fp_sMenuChoice=""
  53. fp_sMenuValue=""
  54. fp_iDisplayCols=11
  55. fp_fCustomQuery=False
  56. BOTID=0
  57. fp_iRegion=BOTID
  58. %>
  59. <!--#include file="_fpclass/fpdbrgn1.inc"-->
  60. <!--webbot bot="DatabaseRegionStart" i-CheckSum="57473" endspan -->
  61. <p style="line-height: 100%; margin-top: 1; margin-bottom: 1"><b><!--webbot
  62. bot="DatabaseResultColumn" startspan
  63. s-columnnames="ID,GradYear,LastName,FirstName,MaidenName,Email,Address,City,State,Zip,Comments,Remote_computer_name,User_name,Browser_type,Timestamp,Telephone,Salutation"
  64. s-column="GradYear" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
  65. local_preview="<font size="-1">&lt;&lt;</font>GradYear<font size="-1">&gt;&gt;</font>"
  66. preview="<font size="-1">&lt;&lt;</font>GradYear<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"GradYear")%><!--webbot
  67. bot="DatabaseResultColumn" i-CheckSum="16523" endspan -->
  68. </b></p>
  69. <p style="line-height: 100%; margin-top: 1; margin-bottom: 1"><!--webbot
  70. bot="DatabaseResultColumn" startspan
  71. s-columnnames="ID,GradYear,LastName,FirstName,MaidenName,Email,Address,City,State,Zip,Comments,Remote_computer_name,User_name,Browser_type,Timestamp,Telephone,Salutation"
  72. s-column="LastName" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
  73. local_preview="<font size="-1">&lt;&lt;</font>LastName<font size="-1">&gt;&gt;</font>"
  74. preview="<font size="-1">&lt;&lt;</font>LastName<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"LastName")%><!--webbot
  75. bot="DatabaseResultColumn" i-CheckSum="14417" endspan -->
  76. , <!--webbot bot="DatabaseResultColumn" startspan
  77. s-columnnames="ID,GradYear,LastName,FirstName,MaidenName,Email,Address,City,State,Zip,Comments,Remote_computer_name,User_name,Browser_type,Timestamp,Telephone,Salutation"
  78. s-column="FirstName" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
  79. local_preview="<font size="-1">&lt;&lt;</font>FirstName<font size="-1">&gt;&gt;</font>"
  80. preview="<font size="-1">&lt;&lt;</font>FirstName<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"FirstName")%><!--webbot
  81. bot="DatabaseResultColumn" i-CheckSum="18712" endspan -->
  82.   <!--webbot bot="DatabaseResultColumn" startspan
  83. s-columnnames="ID,GradYear,LastName,FirstName,MaidenName,Email,Address,City,State,Zip,Comments,Remote_computer_name,User_name,Browser_type,Timestamp,Telephone,Salutation"
  84. s-column="MaidenName" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
  85. local_preview="<font size="-1">&lt;&lt;</font>MaidenName<font size="-1">&gt;&gt;</font>"
  86. preview="<font size="-1">&lt;&lt;</font>MaidenName<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"MaidenName")%><!--webbot
  87. bot="DatabaseResultColumn" i-CheckSum="27090" endspan -->
  88. </p>
  89. <p style="line-height: 100%; margin-top: 1; margin-bottom: 1"><!--webbot
  90. bot="DatabaseResultColumn" startspan
  91. s-columnnames="ID,GradYear,LastName,FirstName,MaidenName,Email,Address,City,State,Zip,Comments,Remote_computer_name,User_name,Browser_type,Timestamp,Telephone,Salutation"
  92. s-column="Address" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
  93. local_preview="<font size="-1">&lt;&lt;</font>Address<font size="-1">&gt;&gt;</font>"
  94. preview="<font size="-1">&lt;&lt;</font>Address<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Address")%><!--webbot
  95. bot="DatabaseResultColumn" i-CheckSum="12103" endspan -->
  96. </p>
  97. <p style="line-height: 100%; margin-top: 1; margin-bottom: 1"><!--webbot
  98. bot="DatabaseResultColumn" startspan
  99. s-columnnames="ID,GradYear,LastName,FirstName,MaidenName,Email,Address,City,State,Zip,Comments,Remote_computer_name,User_name,Browser_type,Timestamp,Telephone,Salutation"
  100. s-column="City" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
  101. local_preview="<font size="-1">&lt;&lt;</font>City<font size="-1">&gt;&gt;</font>"
  102. preview="<font size="-1">&lt;&lt;</font>City<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"City")%><!--webbot
  103. bot="DatabaseResultColumn" i-CheckSum="4267" endspan -->
  104. , <!--webbot bot="DatabaseResultColumn" startspan
  105. s-columnnames="ID,GradYear,LastName,FirstName,MaidenName,Email,Address,City,State,Zip,Comments,Remote_computer_name,User_name,Browser_type,Timestamp,Telephone,Salutation"
  106. s-column="State" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
  107. local_preview="<font size="-1">&lt;&lt;</font>State<font size="-1">&gt;&gt;</font>"
  108. preview="<font size="-1">&lt;&lt;</font>State<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"State")%><!--webbot
  109. bot="DatabaseResultColumn" i-CheckSum="10114" endspan -->
  110.   <!--webbot bot="DatabaseResultColumn" startspan
  111. s-columnnames="ID,GradYear,LastName,FirstName,MaidenName,Email,Address,City,State,Zip,Comments,Remote_computer_name,User_name,Browser_type,Timestamp,Telephone,Salutation"
  112. s-column="Zip" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
  113. local_preview="<font size="-1">&lt;&lt;</font>Zip<font size="-1">&gt;&gt;</font>"
  114. preview="<font size="-1">&lt;&lt;</font>Zip<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Zip")%><!--webbot
  115. bot="DatabaseResultColumn" i-CheckSum="3973" endspan -->
  116. </p>
  117. <p style="line-height: 100%; margin-top: 1; margin-bottom: 1"> <!--webbot
  118. bot="DatabaseResultColumn" startspan
  119. s-columnnames="ID,GradYear,LastName,FirstName,MaidenName,Email,Address,City,State,Zip,Comments,Remote_computer_name,User_name,Browser_type,Timestamp,Telephone,Salutation"
  120. s-column="Email" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
  121. local_preview="<font size="-1">&lt;&lt;</font>Email<font size="-1">&gt;&gt;</font>"
  122. preview="<font size="-1">&lt;&lt;</font>Email<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Email")%><!--webbot
  123. bot="DatabaseResultColumn" i-CheckSum="8328" endspan -->
  124. </p>
  125. <p style="line-height: 100%; margin-left: 5; margin-top: 1; margin-bottom: 1"> <font color="#000080"><!--webbot
  126. bot="DatabaseResultColumn" startspan
  127. s-columnnames="ID,GradYear,LastName,FirstName,MaidenName,Email,Address,City,State,Zip,Comments,Remote_computer_name,User_name,Browser_type,Timestamp,Telephone,Salutation"
  128. s-column="Comments" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
  129. local_preview="<font size="-1">&lt;&lt;</font>Comments<font size="-1">&gt;&gt;</font>"
  130. preview="<font size="-1">&lt;&lt;</font>Comments<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Comments")%><!--webbot
  131. bot="DatabaseResultColumn" i-CheckSum="16369" endspan -->
  132. </font></p>
  133. <hr>
  134. <!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="FALSE"
  135. b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="25"
  136. clientside tag="BODY"
  137. local_preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="center"><font color="#000000">End of Database Results region.</font></td></tr><TR><TD ALIGN=LEFT VALIGN=MIDDLE><FORM><NOBR><INPUT TYPE=Button VALUE="  |<  "><INPUT TYPE=Button VALUE="   <  "><INPUT TYPE=Button VALUE="  >   "><INPUT TYPE=Button VALUE="  >|  ">  [1/25]</NOBR></FORM></td></tr></table>"
  138. preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD ALIGN=LEFT VALIGN=MIDDLE><NOBR><INPUT TYPE=Button VALUE="  |<  "><INPUT TYPE=Button VALUE="   <  "><INPUT TYPE=Button VALUE="  >   "><INPUT TYPE=Button VALUE="  >|  ">  [1/25]</NOBR><BR></td></tr></table>" --><!--#include file="_fpclass/fpdbrgn2.inc"-->
  139. <!--webbot bot="DatabaseRegionEnd" i-CheckSum="62730" endspan -->
  140.  
  141. </body>
  142.  
  143. </html>
  144.