asked on

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.

mrichmon

Can you show the code from the line with the error (line 287) and the surrounding code?

durannyc

ASKER

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"> </td>
<td width="11" height="11"><img src="images/dotted_line_top_corner.gif" width="11" height="11"></td>
<td width="229" height="11"> </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"> </td>
<td width="223" align="left" valign="top"><table width="223" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="22" height="9"> </td>
<td width="157" height="9"> </td>
<td width="44" height="9"><img src="images/white_spacer.gif" width="44" height="9"></td>
</tr>
<tr>
<td width="22"> </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"> </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"> </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"> </td>
</tr>
<tr>
<td width="22" height="11"> </td>
<td width="157" class="dotLineCell" > </td>
<td width="44" height="11"><img src="images/white_spacer.gif" width="44" height="11"></td>
</tr>
<tr>
<td width="22"> </td>
<td width="157" class="addToCartText">[Add to Cart] </td>
<td width="44"> </td>
</tr>
</table></td>
</tr>
<tr>
<td width="265" height="11"> </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"> </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>

durannyc

ASKER

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!"

ASKER CERTIFIED SOLUTION

mrichmon

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial