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