• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 224
  • Last Modified:

Blank repeated region

Blank repeated region
I am unable to find an answer, Please HELP my repeated region is blank?
 
<tr>
    <td height="16"><%=(myrecordset.Fields.Item("ColourID").Value)%></td>
    <td><%=(myrecordset.Fields.Item("Colour").Value)%></td>
    <td><%=(myrecordset.Fields.Item("Default").Value)%></td>
    <td><%=(myrecordset.Fields.Item("LastUpdated").Value)%></td>
    <td><%=(myrecordset.Fields.Item("Inserted").Value)%></td>
    <td><A HREF="TableColours_Update.asp?<%= MM_keepForm & MM_joinChar(MM_keepForm) & "ColourID=" & myrecordset.Fields.Item("ColourID").Value %>">update</A></td>
  </tr>
    <%
While ((Repeat1__numRows <> 0) AND (NOT myrecordset.EOF))
%>
 
  <%
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  myrecordset.MoveNext()
Wend
%>
0
menanova
Asked:
menanova
  • 2
1 Solution
 
jay_eireCommented:
Hi menanova,
I take it this code is from your table?? you need to move your While statement above your table row....
try this.....

  </tr>
    <%
While ((Repeat1__numRows <> 0) AND (NOT myrecordset.EOF))
%>
<tr>
    <td height="16"><%=(myrecordset.Fields.Item("ColourID").Value)%></td>
    <td><%=(myrecordset.Fields.Item("Colour").Value)%></td>
    <td><%=(myrecordset.Fields.Item("Default").Value)%></td>
    <td><%=(myrecordset.Fields.Item("LastUpdated").Value)%></td>
    <td><%=(myrecordset.Fields.Item("Inserted").Value)%></td>
    <td><A HREF="TableColours_Update.asp?<%= MM_keepForm & MM_joinChar(MM_keepForm) & "ColourID=" & myrecordset.Fields.Item("ColourID").Value %>">update</A></td>

 
  <%
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  myrecordset.MoveNext()
Wend
%>

Thanks
Jay Eire
(<>..<>)
0
 
jay_eireCommented:
sorry try this........
   
<%
While ((Repeat1__numRows <> 0) AND (NOT myrecordset.EOF))
%>
<tr>
    <td height="16"><%=(myrecordset.Fields.Item("ColourID").Value)%></td>
    <td><%=(myrecordset.Fields.Item("Colour").Value)%></td>
    <td><%=(myrecordset.Fields.Item("Default").Value)%></td>
    <td><%=(myrecordset.Fields.Item("LastUpdated").Value)%></td>
    <td><%=(myrecordset.Fields.Item("Inserted").Value)%></td>
    <td><A HREF="TableColours_Update.asp?<%= MM_keepForm & MM_joinChar(MM_keepForm) & "ColourID=" & myrecordset.Fields.Item("ColourID").Value %>">update</A></td>
  </tr>
  <%
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  myrecordset.MoveNext()
Wend
%>
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now