Repeat Region on Hortizonal Looper

Forum|Forum|16 years ago
November 11, 2009
1 reply
504 views

My last post I got great help on getting my records to show horizontally , the only issue now that I've come across now is :

How do I get the regions to show 3 record per page , as of now it shows all records per page even with a repeat region set to 3 records set per page

Here is part of the code that I referred off of from other examples, which is currently working minus the repeat region. Also just like to point out that Most of the code is auto generated in dreamweaver so I just use the CF buttons button to generate it all then just edited the code accordingly.

Where would I set the # of products to show up

I also noticed this in a bit of code was in the example provided : <td>#arraysum(yourquery["lotsin"])#</td> not sure if that is relevant...

<td>Products</td>
</tr>
<cfoutput query="RsProdSurf" startRow="#StartRow_RsProdSurf#" maxRows="#MaxRows_RsProdSurf#">
<table width="200" border="1" align="center">
    <tr>
      <cfloop query="RsProdSurf">
        <td>#RsProdSurf.Products#</td>
      </cfloop>

    </tr>

The nex/prev paging

<tr>
      <td><cfif PageNum_RsProdSurf GT 1>
        <a href="#CurrentPage#?PageNum_RsProdSurf=1#QueryString_RsProdSurf#">First</a>
      </cfif></td>
      <td><cfif PageNum_RsProdSurf GT 1>
        <a href="#CurrentPage#?PageNum_RsProdSurf=#Max(DecrementValue(PageNum_RsProdSurf),1)##QueryString_RsProdSurf#">Previous</a>
      </cfif></td>
      <td><cfif PageNum_RsProdSurf LT TotalPages_RsProdSurf>
        <a href="#CurrentPage#?PageNum_RsProdSurf=#Min(IncrementValue(PageNum_RsProdSurf),TotalPages_RsProdSurf)##QueryString_RsProdSurf#">Next</a>
      </cfif></td>
      <td><cfif PageNum_RsProdSurf LT TotalPages_RsProdSurf>
        <a href="#CurrentPage#?PageNum_RsProdSurf=#TotalPages_RsProdSurf##QueryString_RsProdSurf#">Last</a>
      </cfif></td>
    </tr>
</cfoutput>

Once again thanks alot guys, I really do appreciate the help with this , It's been driving me nuts and I must figure it out!!

D

This topic has been closed for replies.

D

Daverms

Inspiring

Hi darylbaker1001,

In which page you experience this problem?.

Since your first part of code contains the maxRows attribute I presume, that might be working correctly for you.

And if you are experience this issue in the next/prev paging, then you need to generate the startrow value and you must assign it to a variable ('StartRow_RsProdSurf" in your case) and can pass through the <a href> statements.

HTH