inconsistent repeat region behavior?

I am trying to use the repeat region behavior for data that I have bound to a page. This is a jewelry site, and for this particular category, some rings may have more than one stone settings. For those specific rings, I need to repeat whatever is in the stone settings (i.e. stone type, cut, clarity, color). I tried to put it in the table where I have the other bound data, but I'm getting a EOF error. See page below:
http://www.skyfacet.com/catalog_details_rings4.asp?ID=100

The strange thing is that when I try to bind the data at another location (bottom of the page), it repeats correctly:
http://www.skyfacet.com/catalog_details_rings3.asp?ID=100

What is the difference between the two? I'm highlighting the appropriate row and selecting the Repeat Region behaviour in Dreamweaver.

Please help.
durannycAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mrichmonCommented:
Can you show the code from the line with the error (line 287) and the surrounding code?
0
durannycAuthor Commented:
Here is the code from that page. I've put a line of '***' to show where the repeat region starts. On another board I was told that I need to requery the data. How would I do that in DW?

<div id="rightContentDetails">
    <table width="550" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td height="30" colspan="3"><table width="100%"  border="0" cellspacing="5" cellpadding="0">
            <tr>
              <td class="productTitleText"><%=(rsDetailsRings.Fields.Item("ProdShortDesc").Value)%></td>
            </tr>
        </table></td>
      </tr>
      <tr>
        <td width="300">&nbsp;</td>
        <td width="11" height="11"><img src="images/dotted_line_top_corner.gif" width="11" height="11"></td>
        <td width="229" height="11">&nbsp;</td>
      </tr>
      <tr>
        <td width="265" height="235" align="center" valign="middle"><img src="<%=(rsDetailsRings.Fields.Item("ProdPic1").Value)%>" name="large" width="300" height="300" id="large"></td>
        <td width="11">&nbsp;</td>
        <td width="223" align="left" valign="top"><table width="223" border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td width="22" height="9">&nbsp;</td>
              <td width="157" height="9">&nbsp;</td>
              <td width="44" height="9"><img src="images/white_spacer.gif" width="44" height="9"></td>
            </tr>
            <tr>
              <td width="22">&nbsp;</td>
              <td width="157"><table width="100%"  border="0" cellspacing="5" cellpadding="0">
                  <tr>
                    <td class="productDetailText"><%=(rsDetailsRings.Fields.Item("ProdLongDesc").Value)%></td>
                  </tr>
                  <tr>
                    <td class="productDetailText"><%=(rsDetailsRings.Fields.Item("AlloyDesc").Value)%></td>
                  </tr>
                  <tr>
                    <td class="productDetailText"><%=(rsDetailsRings.Fields.Item("RingFinish").Value)%></td>
                  </tr>
                  <tr>
                    <td class="productDetailText">Width: <%=(rsDetailsRings.Fields.Item("RingWidth").Value)%></td>
                  </tr>
                  <tr>
                    <td class="productDetailText">Size: <%=(rsDetailsRings.Fields.Item("RingSize").Value)%></td>
                  </tr>
                  <tr>
                    <td class="productDetailText">&nbsp;</td>
                  </tr>
                  <tr>
****************************************************************************
                    <% while ((Repeat2__numRows-- != 0) && (!rsDetailsRings.EOF)) { %>
                    <td class="productDetailText"><%=(rsDetailsRings.Fields.Item("CutName").Value)%> </td>
                    <%  Repeat2__index++;  rsDetailsRings.MoveNext();}%>
                              <% rsDetailsRings.ReQuery %>
</tr>
                  <tr>
                    <td class="productDetailText"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td class="productDetailText"><%=(rsDetailsRings.Fields.Item("StoneType").Value)%></td>
                      </tr>
                      <tr>
                        <td class="productDetailText">&nbsp;</td>
                      </tr>
                      <tr>
                        <td class="productDetailText"><%=(rsDetailsRings.Fields.Item("ClarityCode").Value)%></td>
                      </tr>
                    </table>
                    </td>
                  </tr>
                  <tr>
                    <td class="productPriceText">Price: $<%=(rsDetailsRings.Fields.Item("ProdPrice").Value)%></td>
                  </tr>
              </table></td>
              <td width="44">&nbsp;</td>
            </tr>
            <tr>
              <td width="22" height="11">&nbsp;</td>
              <td width="157" class="dotLineCell" >&nbsp;</td>
              <td width="44" height="11"><img src="images/white_spacer.gif" width="44" height="11"></td>
            </tr>
            <tr>
              <td width="22">&nbsp;</td>
              <td width="157" class="addToCartText">[Add to Cart] </td>
              <td width="44">&nbsp;</td>
            </tr>
        </table></td>
      </tr>
      <tr>
        <td width="265" height="11">&nbsp;</td>
        <td width="11" height="11" align="right" valign="top"><img src="images/dotted_line_bottom_corner.gif" width="11" height="11"></td>
        <td width="223" height="11">&nbsp;</td>
      </tr>
    </table>
    <table width="400"  border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td><div align="center"><img src="<%=(rsDetailsRings.Fields.Item("ProdThumb1").Value)%>" name="thumb1" id="thumb1" style='cursor:hand' onClick="MM_swapImage('large','','<%=(rsDetailsRings.Fields.Item("ProdPic1").Value)%>',1)"></div></td>
        <td><div align="center"><img src="<%=(rsDetailsRings.Fields.Item("ProdThumb2").Value)%>" name="thumb2" id="thumb2" style='cursor:hand' onClick="MM_swapImage('large','','<%=(rsDetailsRings.Fields.Item("ProdPic2").Value)%>',1)"></div></td>
        <td><div align="center"><img src="<%=(rsDetailsRings.Fields.Item("ProdThumb3").Value)%>" name="thumb3" id="thumb3" style='cursor:hand' onClick="MM_swapImage('large','','<%=(rsDetailsRings.Fields.Item("ProdPic3").Value)%>',1)"></div></td>
      </tr>
      <tr valign="top" class="productPriceText">
        <td colspan="3"><p align="center">Click on the images above to see different views</p>
        </td>
      </tr>
    </table>  
    <% while ((Repeat1__numRows-- != 0) && (!rsDetailsRings.EOF)) { %>
    <a class="productDetailText"><%=(rsDetailsRings.Fields.Item("CutName").Value)%></a><br>
    <%
  Repeat1__index++;
  rsDetailsRings.MoveNext();
}
%>
</div>
0
durannycAuthor Commented:
On another board this was suggested before the next record query:
<%RecordsetName.MoveFirst()%>

I actually used this code:
<%=(rsDetailsRings.MoveFirst)%>

and it works. Is there any difference from a performance standpoint? Otherwise, I'll leave it as is.

"If it ain't broke, don't try to fix it!"
0
mrichmonCommented:
Sorry I didn't respond sooner - I was out of town.

The difference is that you may need the = in .NET and you don't in regular asp.  But it will work with the = in both.

There really is no other difference....

I would leave it as you have it.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.