Easy One - Record Set Output, but not paged - output to all one page.

PaulGQ · #1 (**permalink**) 04-16-04, 22:45

OK here is it. My recordset is 52 rows long.

I want to limit the output to 13 rows, then not page, but continue as columns in a table.

This will give my singe page one table with 4 columns - 13 rows in each column, not 4 pages of recordset data.

I know this can easily be done, but I can't figure out how.

ASP-Hosting.ca · #2 (**permalink**) 04-19-04, 09:40

You can do this with 2 nested loops, displaying something like:

Code:

<table>
  <tr>
    <td>
      <table>
         <tr><td>Row1</td></tr>
         <tr><td>Row2</td></tr>
         .......
         <tr><td>Row13</td></tr>
      </table>
    </td>
    <td>
      <table>
         <tr><td>Row14</td></tr>
         <tr><td>Row15</td></tr>
         .......
         <tr><td>Row26</td></tr>
      </table>
      .........
          <td>
      <table>
         <tr><td>Row40</td></tr>
         <tr><td>Row41</td></tr>
         .......
         <tr><td>Row52</td></tr>
      </table>
    </td>
    </td>
  </tr>
</table>

thele · #3 (**permalink**) 04-19-04, 10:39

Yeah, it's going to take some hideous code, but ASP-Hosting.ca is right.

Alternatively what you can do is add 13 to your loop. It is easier if you put the recordset into an array first. Here is basically what it would look like:

Pseudo code:

Quote:

RSarray = Recordset.getrows
For z = 0 to ubound(RSarray,2)
  <td>Column1 = RSarray(0,z) </td>
  <td>Column2 = RSarray(0,z+13) </td>
  <td>Column3 = RSarray(0,z+26) </td>
Next

You need to make sure that z+13 is not greater than ubound(RSarray,2), but you should be able to figure out that code (if you can't then you need to go back to school).

~Le

PaulGQ · #4 (**permalink**) 04-19-04, 10:51

Any idea of the nested loop syntax?

thele · #5 (**permalink**) 04-19-04, 12:57

Internet Services

Web Development

Digital Marketing

Consumer Tech