Skip navigation
gbergan52
gbergan52 Calculating status...
Currently Being Moderated

How to change the display limits of a dynamic table?

Mar 17, 2011 12:48 PM

Hi folks,

 

I'm using DW CS4 and PHP. I've got a php page with a dynamic table and repeating region that I built for my client. This table lists our entire active member list. Initially I built the dynamic table to show only 50 records at a time because 300+ records made an overly long page. Now my client wants all the records on a single page, because he doesn't like clicking through the recordset paging of First - Next - Previous - Last list to find who he is looking for. I tried changing the Repeating Region behavior to All Records (rather than 50) but it still displays only 50. I'm sure this is because initially when I set up the dynamic table, I limited it to 50 there. Is there an easy way to change the dynamic table from 50 to All Records, without rebuilding the entire page? I've looked in several places and can't find a way to edit this. Thanks for your help,

 

Gail

320 Views   10 Replies   Latest reply: Günter Schenk, Mar 18, 2011 9:55 AM
 
Replies
  • arnhemcs-Qfa7k6
    Currently Being Moderated
    1. arnhemcs-Qfa7k6,
    Mar 17, 2011 1:25 PM   in reply to gbergan52
    Report

    There is probably gone something wrong in your code.

    You must be able to find it.

    With me it sometimes occurs that a code is placed twice

    where the old one is shown last and therefore overwrites the newly placed code.

     

    I am not really a programmer so there are people around here that can help you better.

    But maybe it is worth while to look if this has occurred.

     

    Jos

     
    |
    Mark as:
  • Günter Schenk
    Currently Being Moderated
    2. Günter Schenk,
    Mar 17, 2011 5:27 PM   in reply to gbergan52
    Report

    If the page in question is - apart from the table - not overly complex, the probably most straight forward way is to...

     

    a) copy the table *code* to the clipboard and paste it into, say, a simple text editor such as NotePad

     

    b) rename the current document to something else for backup purposes

     

    c) create a new document and insert a simple Recordset (needs to be named identically to allow for an easy transition)

     

    d) paste the table code back in here

     
    |
    Mark as:
  • gbergan52
    Currently Being Moderated
    3. gbergan52,
    Mar 18, 2011 8:02 AM   in reply to Günter Schenk
    Report

    Thanks, that did the trick!

     

    Gail

     
    |
    Mark as:
  • Günter Schenk
    Currently Being Moderated
    4. Günter Schenk,
    Mar 18, 2011 8:21 AM   in reply to gbergan52
    Report

    gbergan52 wrote:

     

    Thanks, that did the trick!

    and it´s much easier than having to delete all that redundant code garbage ;-)

     
    |
    Mark as:
  • gbergan52
    Currently Being Moderated
    5. gbergan52,
    Mar 18, 2011 8:26 AM   in reply to Günter Schenk
    Report

    Gunter,

     

    Thanks for your continued help on this forum. You have made people's

    work a lot easier and stuck with them through some thorny issues.

     

    If I may redirect you to an issue I had a few months back - the initial

    posting was here at:

    http://forums.adobe.com/thread/767154?tstart=300

     

    I couldn't turn the answers I received into a workable solution. Would

    you be willing to take a look at this?

     

    Thanks again for your help,

     

    Gail

     
    |
    Mark as:
  • Günter Schenk
    Currently Being Moderated
    6. Günter Schenk,
    Mar 18, 2011 8:56 AM   in reply to gbergan52
    Report

    Hi Gail,

     

    this is doable and doesn´t take much effort, but I need to know if you still want this applied to a "recordset paging" document or if it´s based on a simple query.

     
    |
    Mark as:
  • gbergan52
    Currently Being Moderated
    7. gbergan52,
    Mar 28, 2011 6:22 PM   in reply to Günter Schenk
    Report

    I believe the answer is a recordset paging document. If I can do A,B,C

    navigation to our member list, then we don't have to have that ugly full

    page of all 300+ members. This is what I was originally trying to do

    (not list them all on a single page as you have helped me with), but I

    couldn't accomplish it. My recordset consists of firstname, lastname,

    userID and email. Then I have a separate column we can link on, where we

    can either Edit each member, or Delete them.

     

    Thanks.

     

    Message was edited by: Günter Schenk. Reason: Contact details removed at the request of the OP

     
    |
    Mark as:
  • Günter Schenk
    Currently Being Moderated
    8. Günter Schenk,
    Mar 18, 2011 9:19 AM   in reply to gbergan52
    Report

    gbergan52 wrote:

     

    I believe the answer is a recordset paging document.

    No problem either, but please tell me, if the current query already contains a WHERE clause or not.

     
    |
    Mark as:
  • gbergan52
    Currently Being Moderated
    9. gbergan52,
    Mar 28, 2011 6:23 PM   in reply to Günter Schenk
    Report

    Yes. We filter on "activity status" of members (y or n), so it doesn't

    pull up inactive members (those who have let their membership lapse).

     

    Gail

     

    Message was edited by: Günter Schenk. Reason: Contact details removed at the request of the OP

     
    |
    Mark as:
  • Günter Schenk
    Currently Being Moderated
    10. Günter Schenk,
    Mar 18, 2011 9:55 AM   in reply to gbergan52
    Report

    Thanks,

     

    I have figured out something by now and will add the "how to" to that other thread you mentioned so it stays within the context of your initial post.

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points