p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

proasp_codeclinic thread: How do I link an Index table with Recordset Table


Message #1 by NddyMyke@a... on Wed, 13 Jun 2001 11:10:29 EDT
I have a table of recordset and another table of link Indexes.

What I do want to achieve is, if a letter in the link indexes is clicked all rows with that letter should be displayed at the top of
the recordset table.
It seems to work for the "A" index but the rest doesn't.

Can you please assist.

Here is part of the  code

<table width="384" border="0" align="center">
<tr bordercolor="#FFFFFF"> 
<td><a href="#a"><font face="Arial, Helvetica, sans-serif">A</font></a> 
<font face="Arial, Helvetica, sans-serif"><a"#b">B</a> 
<a href="#c">C</a> <a href="#d">D</a><a ref="#e">E</a> <a href="#f">F</a> <a
href="#g">G</a> <a ref="#h">H</a> <a href="#i">I</a> <a href="#j">J</a> <a
ref="#k">K</a> <a href="#l">L</a> <a href="#m">M</a> <a ref="#n">N</a> 
<a href="#o">O</a> <a href="#p">P</a> <a ref="#q">Q</a> <a href="#r">R</a> <a
href="#s">S</a> <a ref="#t">T</a> <a href="#u">U</a> <a href="#v">V</a> <a
ref="#w">W</a> <a href="#x">X</a> <a href="#y">Y</a> <a ref="#z">Z</a> 
</font></td>
</tr>
</table>


<% do while not rsBSCSign.EOF %>    
<%  
    Response.Write "<tr align=""left"" valign=""top"">" & _                 
    " <td class=""bodytext""><a name=""a""><font size=2 face=""Arial"">" & rsBSCSign("CompanyName") & _
    " </font></a></td>"             
%>                          
<%  Response.Write "<td><font size=2 face=""Arial"">" & rsBSCSign("Address") &  " </font></td>" %>
                    
<%rsBSCSign.MoveNext %>                 
<% loop  %>                                              
<% rsBSCSign.Close %>

  Return to Index