<form BOTID="0" METHOD="POST" ACTION="rank.asp">
  <table BORDER="0">
    <tr>
      <td><b>Rank</b></td>
      <td><input TYPE="TEXT" NAME="Rank" VALUE="<%=Request("Rank")%>" size="20"></td>
    </tr>
  </table>
  <p>Example PSG&nbsp; SGT SP4 SSG</p>
  <p><br>
  <input TYPE="Submit"><input TYPE="Reset"><!--webbot bot="SaveAsASP" clientside suggestedext="asp" preview=" " startspan --><!--webbot bot="SaveAsASP" endspan --></p>
  <p>&nbsp;</p>
</form>
<table width="100%" border="1">
  <thead>
    <tr>
      <td><b>LName</b></td>
      <td><b>FName</b></td>
      <td><b>MI</b></td>
      <td><b>NSuffix</b></td>
      <td><b>NName</b></td>
      <td><b>City</b></td>
      <td><b>State</b></td>
      <td><b>Zip9</b></td>
      <td><b>U1</b></td>
      <td><b>U1From</b></td>
      <td><b>U1To</b></td>
      <td><b>U1Com</b></td>
      <td><b>Rank</b></td>
      <td><b>FieldRep</b></td>
      <td><b>LastUpdt</b></td>
    </tr>
  </thead>
  <tbody>
    <!--webbot bot="DatabaseRegionStart" s-columnnames="PostRef,LName,FName,MI,NSuffix,NName,Addr,City,State,Zip9,Phone,Caddr,ReleaseBox,U1,U1From,U1To,U1Com,MemNo,MemType,MemExp,SSN,SN,Rank,FieldRep,LastUpdt" s-columntypes="5,200,200,200,200,200,200,200,200,200,200,200,200,200,135,135,200,5,200,200,200,200,200,200,135" s-dataconnection="Database5" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="TRUE" s-recordsource="TDiskMastShort" s-displaycolumns="LName,FName,MI,NSuffix,NName,City,State,Zip9,U1,U1From,U1To,U1Com,Rank,FieldRep,LastUpdt" s-criteria="[Rank] EQ {Rank} +" s-order s-sql="SELECT * FROM &quot;TDiskMastShort&quot; WHERE (Rank =  '::Rank::')" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="Rank=" s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="5" botid="0" u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-dbrgn2="../_fpclass/fpdbrgn2.inc" tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the start of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include file="../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ""TDiskMastShort"" WHERE (Rank =  '::Rank::')"
fp_sDefault="Rank="
fp_sNoRecords="<tr><td colspan=15 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Database5"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=15
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan --><tr>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="PostRef,LName,FName,MI,NSuffix,NName,Addr,City,State,Zip9,Phone,Caddr,ReleaseBox,U1,U1From,U1To,U1Com,MemNo,MemType,MemExp,SSN,SN,Rank,FieldRep,LastUpdt" s-column="LName" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;LName&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"LName")%><!--webbot bot="DatabaseResultColumn" endspan --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="PostRef,LName,FName,MI,NSuffix,NName,Addr,City,State,Zip9,Phone,Caddr,ReleaseBox,U1,U1From,U1To,U1Com,MemNo,MemType,MemExp,SSN,SN,Rank,FieldRep,LastUpdt" s-column="FName" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;FName&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"FName")%><!--webbot bot="DatabaseResultColumn" endspan --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="PostRef,LName,FName,MI,NSuffix,NName,Addr,City,State,Zip9,Phone,Caddr,ReleaseBox,U1,U1From,U1To,U1Com,MemNo,MemType,MemExp,SSN,SN,Rank,FieldRep,LastUpdt" s-column="MI" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;MI&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"MI")%><!--webbot bot="DatabaseResultColumn" endspan --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="PostRef,LName,FName,MI,NSuffix,NName,Addr,City,State,Zip9,Phone,Caddr,ReleaseBox,U1,U1From,U1To,U1Com,MemNo,MemType,MemExp,SSN,SN,Rank,FieldRep,LastUpdt" s-column="NSuffix" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;NSuffix&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"NSuffix")%><!--webbot bot="DatabaseResultColumn" endspan --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="PostRef,LName,FName,MI,NSuffix,NName,Addr,City,State,Zip9,Phone,Caddr,ReleaseBox,U1,U1From,U1To,U1Com,MemNo,MemType,MemExp,SSN,SN,Rank,FieldRep,LastUpdt" s-column="NName" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;NName&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"NName")%><!--webbot bot="DatabaseResultColumn" endspan --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="PostRef,LName,FName,MI,NSuffix,NName,Addr,City,State,Zip9,Phone,Caddr,ReleaseBox,U1,U1From,U1To,U1Com,MemNo,MemType,MemExp,SSN,SN,Rank,FieldRep,LastUpdt" s-column="City" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;City&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"City")%><!--webbot bot="DatabaseResultColumn" endspan --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="PostRef,LName,FName,MI,NSuffix,NName,Addr,City,State,Zip9,Phone,Caddr,ReleaseBox,U1,U1From,U1To,U1Com,MemNo,MemType,MemExp,SSN,SN,Rank,FieldRep,LastUpdt" s-column="State" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;State&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"State")%><!--webbot bot="DatabaseResultColumn" endspan --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="PostRef,LName,FName,MI,NSuffix,NName,Addr,City,State,Zip9,Phone,Caddr,ReleaseBox,U1,U1From,U1To,U1Com,MemNo,MemType,MemExp,SSN,SN,Rank,FieldRep,LastUpdt" s-column="Zip9" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Zip9&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"Zip9")%><!--webbot bot="DatabaseResultColumn" endspan --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="PostRef,LName,FName,MI,NSuffix,NName,Addr,City,State,Zip9,Phone,Caddr,ReleaseBox,U1,U1From,U1To,U1Com,MemNo,MemType,MemExp,SSN,SN,Rank,FieldRep,LastUpdt" s-column="U1" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;U1&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"U1")%><!--webbot bot="DatabaseResultColumn" endspan --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="PostRef,LName,FName,MI,NSuffix,NName,Addr,City,State,Zip9,Phone,Caddr,ReleaseBox,U1,U1From,U1To,U1Com,MemNo,MemType,MemExp,SSN,SN,Rank,FieldRep,LastUpdt" s-column="U1From" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;U1From&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"U1From")%><!--webbot bot="DatabaseResultColumn" endspan --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="PostRef,LName,FName,MI,NSuffix,NName,Addr,City,State,Zip9,Phone,Caddr,ReleaseBox,U1,U1From,U1To,U1Com,MemNo,MemType,MemExp,SSN,SN,Rank,FieldRep,LastUpdt" s-column="U1To" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;U1To&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"U1To")%><!--webbot bot="DatabaseResultColumn" endspan --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="PostRef,LName,FName,MI,NSuffix,NName,Addr,City,State,Zip9,Phone,Caddr,ReleaseBox,U1,U1From,U1To,U1Com,MemNo,MemType,MemExp,SSN,SN,Rank,FieldRep,LastUpdt" s-column="U1Com" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;U1Com&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"U1Com")%><!--webbot bot="DatabaseResultColumn" endspan --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="PostRef,LName,FName,MI,NSuffix,NName,Addr,City,State,Zip9,Phone,Caddr,ReleaseBox,U1,U1From,U1To,U1Com,MemNo,MemType,MemExp,SSN,SN,Rank,FieldRep,LastUpdt" s-column="Rank" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Rank&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"Rank")%><!--webbot bot="DatabaseResultColumn" endspan --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="PostRef,LName,FName,MI,NSuffix,NName,Addr,City,State,Zip9,Phone,Caddr,ReleaseBox,U1,U1From,U1To,U1Com,MemNo,MemType,MemExp,SSN,SN,Rank,FieldRep,LastUpdt" s-column="FieldRep" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;FieldRep&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"FieldRep")%><!--webbot bot="DatabaseResultColumn" endspan --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="PostRef,LName,FName,MI,NSuffix,NName,Addr,City,State,Zip9,Phone,Caddr,ReleaseBox,U1,U1From,U1To,U1Com,MemNo,MemType,MemExp,SSN,SN,Rank,FieldRep,LastUpdt" s-column="LastUpdt" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;LastUpdt&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"LastUpdt")%><!--webbot bot="DatabaseResultColumn" endspan --></td>
    </tr>
    <!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="5" clientside tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the end of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD ALIGN=LEFT VALIGN=MIDDLE COLSPAN=64&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button VALUE=&quot;  |&lt;  &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot;   &lt;  &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot;  &gt;   &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot;  &gt;|  &quot;&gt;  [1/5]&lt;/NOBR&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan --></tbody>
</table>
