Forums

ASP

This topic is locked

Problems viewing all records

Posted 12 Mar 2003 17:36:25
1
has voted
12 Mar 2003 17:36:25 Irene Unpingco posted:
Using MX, I created a Master/Detail set of pages. The problem I'm having is that the detail page is not showing all the records. It tells me there are 340 records, but once you get to 170, I get nothing.

Does anyone know what might have caused this? Should I look in the DB (MS Access), or in the pages themselves?

Thanks!

live from the corner cubicle

Replies

Replied 12 Mar 2003 20:36:34
12 Mar 2003 20:36:34 Jerry Rulewicz replied:
Are your results being deisplayed in a repeat region? If so check to see that the repeat region is set to display all records.
Replied 12 Mar 2003 21:37:06
12 Mar 2003 21:37:06 Irene Unpingco replied:
I went ahead and did as you said, and I double checked my "Display Records." I reassigned it so that it displayed all records, and now I can see all of them, but they're all on one page...

The pages themselves are very simple. If you want to see them, they are at:

wwww.nmsu.edu/projmgt

If you go into "View Records," right now, they are all on one page. If I set it up like it was before, it stops at 170...maybe I did what you asked incorrectly...?

live from the corner cubicle
Replied 12 Mar 2003 22:42:30
12 Mar 2003 22:42:30 Jerry Rulewicz replied:
I think your link in previous post is bad....post it again

Is your new page with the modified repeat region working?

If you don't want all your records displayed at once on a page set the repeat region to display a set amount and add recordset paging behaviors to scroll through the records
Replied 12 Mar 2003 23:13:33
12 Mar 2003 23:13:33 Irene Unpingco replied:
Let me try again...

wwww.nmsu.edu/projmgt/

There's 4 w's (wwww) and the program does NOT like it...so clicking on the link doesn't work. Sorry... <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

I had had the paging behaviors set up to page through the records in sets of 10, but it mysteriously stopped at 170.

Here's part of the code
var rsmasterset3_numRows = 0;

var Repeat1__numRows = -1;
var Repeat1__index = 0;
rsmasterset3_numRows += Repeat1__numRows;
// set the record count
var rsmasterset3_total = rsmasterset3.RecordCount;

// set the number of rows displayed on this page
if (rsmasterset3_numRows &lt; 0) { // if repeat region set to all records
rsmasterset3_numRows = rsmasterset3_total;
} else if (rsmasterset3_numRows == 0) { // if no repeat regions
rsmasterset3_numRows = 1;
}

// set the first and last displayed record
var rsmasterset3_first = 1;
var rsmasterset3_last = rsmasterset3_first + rsmasterset3_numRows - 1;

// if we have the correct record count, check the other stats
if (rsmasterset3_total != -1) {
rsmasterset3_numRows = Math.min(rsmasterset3_numRows, rsmasterset3_total);
rsmasterset3_first = Math.min(rsmasterset3_first, rsmasterset3_total);
rsmasterset3_last = Math.min(rsmasterset3_last, rsmasterset3_total);
}

live from the corner cubicle

Reply to this topic