Repeat Region Dynamically change items per page

Question

Hi

Can anyone help on this one? I've set up a standard recordset
(page uses ASP VB) to pull back a list of products, I wanted to
give the user the option to be able to select the number of product
shown per page (10, 25, 50 etc.) using a menu field, so I edited
the repeat region behaviour so that the line now pulls the variable
from the form Repeat1__numRows = Request.Form("itemsperpage"). This
works great, the form field submits onChange and the number of
products shown changes correctly.

The problem is that when you first load the page no products
are shown until you select a number from the form field. So, to try
to get over this I then added an onload event to the body tag to
submit the page but then the problem happens that the page
continually reloads itself, I've also tried some javascript so that
the page just reloads the once but to no avail.

Basically, I just want an initial number of products to show
when the page loads, then to be able to use the form field to allow
the user to alter the number shown per page.

Many thanks if anyone has any idea how I can best achieve
this.

Cheers

xetra21 · Accepted Answer

Setting a default value wouldn't work, the solution did however come to me and seems to work OK. Here's the new repeat region code:

<%
Dim Repeat1__numRows
Dim Repeat1__index

If Request.Form("itemsperpage")="" Then
Repeat1__numRows = 20
Else
Repeat1__numRows = Request.Form("itemsperpage")
End if

Repeat1__index = 0
rsProducts_numRows = rsProducts_numRows + Repeat1__numRows
%>

Newsgroup_User · Answer

xetra21 wrote:> Setting a default value wouldn't work, the solution didhowever come to me and > seems to work OK. Here's the new repeat region code:What you have done *is* setting a default value, its how I doit. Congrats for working it out!Dooza

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.