Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

inconsistent repeat region behavior?

Posted on 2004-10-26
4
Medium Priority
?
297 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
Comment
Question by:durannyc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 35

Expert Comment

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

Author Comment

by:durannyc
ID: 12422310
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
ID: 12447586
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:
mrichmon earned 375 total points
ID: 12464289
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
Originally, this post was published on Monitis Blog, you can check it here . It goes without saying that technology has transformed society and the very nature of how we live, work, and communicate in ways that would’ve been incomprehensible 5 ye…
The purpose of this video is to demonstrate how to insert an Iframe into WordPress. 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 : Open Page or Post…
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…
Suggested Courses

610 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