Link to home
Start Free TrialLog in
Avatar of menanova
menanova

asked on

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
%>
Avatar of jay_eire
jay_eire
Flag of United States of America image

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
(<>..<>)
ASKER CERTIFIED SOLUTION
Avatar of jay_eire
jay_eire
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial