Paging Recordsets

[arundahar]

I have 2 recordsets that i need to span over multiple pages if there is more than 30 records in EITHER of them or if the total no. of records is MORE than 30 - i.e if rsA has 7 records and rsB has 48 i need to display all 7 rsA records and then 23 records of rsB and display the rest on another page. Anyone know how to do this? This is the most complex paging i've ever attempted and am pretty stuck!!

HELP!

Cheers

Arun

 

[jmcpher]

You should be able to, using a counter, end pages once 30 records have been written out. To end a page you can put:

<p style=&quot;page-break-before:always;&quot;></p>

this is supposed to work for IE 4, but I have had a few glitches.

I am just now thinking you might mean to put them on different .asp pages, sooo, try this:

Dim rsA
Set rsA = Server.CreateObject(&quot;ADODB.RecordSet&quot
rsA.Open sql, conn, 3, 1

this will give you rsA.AbsolutePosition which will let you jump to the correct record, which you may have to pass in a querystring variable. &quot;A computer scientist is a person who knows when it is time to hit the computer.&quot;

John

johnmc@mvmills.com