2 Replies Latest reply on Oct 9, 2010 9:43 AM by theMachien

    Not able to have more than 1 repeat region?????

    theMachien

      I am working on an ASP page w/ Access DB that I would like to have 3 record sets that each pull different info from the same table.

      rs_FloorPlans1000

      rs_FloorPlans2000

      rs_FloorPlans3000

       

       

      I have created 3 seperate tables

       

      tbl1000 - floors plans from 1000sq ft - 1999 sq ft

      tbl2000 - floors plans from 2000sq ft - 2999 sq ft

      tbl3000 - floors plans from 3000sq ft - and up

       

      Each table to hold just an Image of a floor plan that should repeat horizontally for 3 colums using the Tom Muck Horizontal Looper 2 Extension.

       

       

      <td align="center" id="clickDetails"><a href="#" onclick="MM_openBrWindow('aspenhomes_FloorPlanDetail.asp?<%= Server.HTMLEncode(MM_keepNone) & MM_joinChar(MM_keepNone) & "ID=" & rs_FloorPlans_1000.Fields.Item("ID").Value %>','floorDetails','resizable=yes,width=650,height=875')">(Click Here for Details)</a></td>
                    </tr>
                  </table></td>
                </tr>
              </table>
      <table width="100%" border="0" cellpadding="0" cellspacing="0" id="outerTable">
                <tr>
                  <td align="center"><table>
                    <%
      startrw = 0
      endrw = HLooper2__index
      numberColumns = 3
      numrows = -1
      while((numrows <> 0) AND (Not rs_FloorPlans_1000.EOF))
          startrw = endrw + 1
          endrw = endrw + numberColumns
      %>
                    <tr align="center" valign="top">
                      <%
      While ((startrw <= endrw) AND (Not rs_FloorPlans_1000.EOF))
      %>

       

      the SQL statement work and look like this

       

      rs_FloorPlans_1000

      SELECT *

      FROM tb_adminFloorPlans

      WHERE floorPlanSquareFt

      BETWEEN '1000 sq. ft.' AND '1999 sq. ft.'

      ORDER BY floorPlanSquareFt ASC"

       

      rs_FloorPlans_2000

      SELECT *

      FROM tb_adminFloorPlans

      WHERE floorPlanSquareFt

      BETWEEN '2000 sq. ft.' AND '2999 sq. ft.'

      ORDER BY floorPlanSquareFt ASC"

       

      rs_FloorPlans_3000

      SELECT * F

      ROM tb_adminFloorPlans

      WHERE floorPlanSquareFt > ?

      ORDER BY floorPlanSquareFt ASC

       

      Now if I just try and repeat the first record set for tbl1000 it works fine. But If I try and do the same for the remaining tables I get nothing. The image even is gone that will appear if their is no repeat.

       

      You can see the page here..

       

      http://bigfootdesigns.com/new-aspenhomes/aspenhomes_FloorPlans.asp

       

      thanks

       

      B

        • 1. Re: Not able to have more than 1 repeat region?????
          Brad Lawryk Adobe Community Professional & MVP

          I haven't used ASP in many years - but I know you should be able to have more than one repeat region. I would suggest that this may be a question for Tom Muck as it may be that that particular extension may not be able to be applied more than once per page?

           

          Brad Lawryk

          Adobe Community Professional: Dreamweaver

          Northern British Columbia Adobe Usergroup: Manager

          Thompson Rivers University: Dreamweaver Instructor

          My Adobe Blog: http://blog.lawryk.com

          • 2. Re: Not able to have more than 1 repeat region?????
            theMachien Level 1

            Figured it out. I was not changing the record set when appling the extension..

             

            Look at the code and the rsDB1 is called in each record...

             

            <%
            Dim HLooper1__numRows
            HLooper1__numRows  = -3
            Dim HLooper1__index
            HLooper1__index = 0
            rsDB1_numRows =  rsDB1_numRows + HLooper1__numRows
            %>
            <%
            Dim  HLooper2__numRows
            HLooper2__numRows = -3
            Dim  HLooper2__index
            HLooper2__index = 0
            rsDB1_numRows = rsDB1_numRows +  HLooper2__numRows
            %>
            <%
            Dim  HLooper3__numRows
            HLooper3__numRows = -3
            Dim  HLooper3__index
            HLooper3__index = 0
            rsDB1_numRows = rsDB1_numRows +  HLooper3__numRows
            %>

             

            This is the correct code when the right record set is choosen..

             

            <%
            Dim HLooper1__numRows
            HLooper1__numRows = -3
            Dim HLooper1__index
            HLooper1__index = 0
            rsDB1_numRows = rsDB1_numRows + HLooper1__numRows
            %>
            <%
            Dim HLooper2__numRows
            HLooper2__numRows = -3
            Dim HLooper2__index
            HLooper2__index = 0
            rsDB2_numRows = rsDB2_numRows + HLooper2__numRows
            %>
            <%
            Dim HLooper3__numRows
            HLooper3__numRows = -3
            Dim HLooper3__index
            HLooper3__index = 0
            rsDB3_numRows = rsDB3_numRows + HLooper3__numRows
            %>

             

            I-D-10-T error i guess....

             

            thanks

             

            B