Problem With Displaying Information

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I am having a problem with displaying information. I believe that it's a problem with the table. Please look at http://www.themacedoniachurch.org/staff2.asp. Look at how the buttons and header are displayed every time a record is displayed. I believe that there's a typo somewhere in my code. Can someone please help me? I'd like for it to look something like http://www.madisonheightsbaptist.org/staff.asp. 

Here's my code:

'Start sql string 
      sqlString = "select * from MMBCStaff Order by StaffID"
                 &nbs p;  
      'Create the recordset
      set rs = Server.CreateObject("ADODB.Recordset")
      rs.Open sqlString, connectionString, adOpenDynamic, adLockOptimistic

      'Set the current record pointer to the first record of the recordset
      rs.MoveFirst 

      'Loop through all the records in the recordset
      while not rs.EOF 

      'Get values for local variables

      StaffName = rs("Name") & ""
      Position = rs("Title") & ""
      Email = rs("Email") & ""
      Bio = rs("Bio") & ""

%>
<html>
<head>
<title>About Us</title>
<!--#include file="Include_Buttons.asp"--></td>
    <td rowspan="2" valign="top">
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
        <!--DWLayoutTable-->
        <tr> 
          <td width="9" height="1320">&nbsp;</td>
          <td width="529" valign="top"> <p><strong><font size="6">Our Staff</font></strong></p>
            <% 
            If Email <> "" then
            %> 
   <font face="Arial, Helvetica, sans-serif" size=3><a href="mailto:<%= Email %>"><%= StaffName %></a>,&nbsp;<b><%= Position %></font></b>
       <% else %>
    <font face="Arial, Helvetica, sans-serif" size=3><%= StaffName %>,&nbsp;<b><%= Position %></b></font>
    <% end if %>
      <%      
  rs.MoveNext 
        wend
%>
   <p>&nbsp;</p>
            <p><br>
            </p>
            </td>
        </tr>
        <tr bgcolor="#CCCC99"> 
          <td height="68" colspan="2" valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>
        </tr>
      </table></td>
  </tr>
  <tr> 
    <td height="687" valign="top">
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
        <!--DWLayoutTable-->
        <tr> 
          <td width="201" height="619">&nbsp;</td>
        </tr>
        <tr>
          <td height="68" valign="top" bgcolor="#CCCC99"><!--DWLayoutEmptyCell-->&nbsp;</td>
        </tr>
      </table></td>
  </tr>
  <tr> 
    <td height="52">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</table>
</body>
</html>
<%
'Close the recordset and connection string
rs.Close
set rs = Nothing
set ConnectionString = Nothing 
%>