Another one from me....

I have a page which displays, via a repeat region, all the members of the club where their status is "in good standing". That's easy enough. The issue is a UI thing since the list is very long it requires lots of scrolling. I would like to take the number of records, divide them in half and display the first half on the right and the second half on the left of the page. I have written a SQL count statement that will tell me the number of records that match "in good standing" from the database and can easily divide that in half (with appropriate rounding). My challenge is coming in how i display the half and half. I have tried to figure this out using record set paging but I'm not sure exactly how you do it since I'm using a single page.

Oh yeah, the page is asp with javascript as the default language.

Any help is greatly appreciated.

I remember seeing a tutorial on this, here on DMXzone. Check out the tutorial section: www.dmxzone.com/categories.asp?TypeId=2 and I remember seeing something about it, was only a couple steps to alter the Repeat Region and get two or more columns.

You could also look at Horizontal Looper by Tom Muck
www.tom-muck.com/extensions/help/HorizontalLooper/

Live the life you love
Love the life you live

Simon

[DWMX 2004]|[SQL]|[ASP/VBScript]|[XP-Pro]

basically, in your first repeat region. ie the left side, it starts at index=1, now say this has ten records in it.

so now on repeat region 2, which is in the right hand table, you need to edit the code generated by dw so that index starts at 11.

get it? 1+10 =11 so rpt region 2 carries on where rpt region 1 finshed, quite cool for making some mad record designs <img src=../images/dmxzone/forum/icon_smile_tongue.gif border=0 align=middle>

regards
Dave