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?
 
mrichmonConnect With a Mentor Commented:
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
 
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
All Courses

From novice to tech pro — start learning today.