Solved

inconsistent repeat region behavior?

Posted on 2004-10-26
243 Views
Last Modified: 2012-05-05
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.
0
Question by:durannyc
    4 Comments
     
    LVL 35

    Expert Comment

    by:mrichmon
    Can you show the code from the line with the error (line 287) and the surrounding code?
    0
     

    Author Comment

    by:durannyc
    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
     

    Author Comment

    by:durannyc
    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
     
    LVL 35

    Accepted Solution

    by:
    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    When deciding to adopt any help desk solutions many factors should be explored before taking decisions. This will change from business to another but in general there are some kind of rule of thumb. Here are some quick tips: Do we need only ticket…
    In this short web based tutorial, I wanted to show users how they can still use the powers of FrontPage in conjunction with Expression Web 3.  Even though Microsoft eliminated the use of Web components, we can still use them with FrontPage and edit …
    The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…
    The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…

    933 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now