Formatting Database results with ASP

[traeanthony]

I'm currently developing a site that is pulling information from a database and placeing it into a table. The table will need to be a max of 5 cells across and 3 cells down (depending on how many records there are to display). I also need to page the results (15 results max per page)

The problem is I don't know how to script the ASP to make this all happen.

Does anyone know how to accomplish this, or know of a site that can guide me how to make it?

Any help is appreciated.

Thanks!

[Easy_Coder]

plug this search into google and that should get you on the right road:

paging +asp

[traeanthony]

Thanks! I found plenty on paging my results. Now I still have the problem of displaying the information from the database. Basically what I need is a table that is 5 cells wide and 3 cells high. Each record set will be displayed in one cell (up to 15 record sets per page for how ever many pages needed) Any clues?

[celgins]

The ASP (VBScript) paging features, such as AbsolutePage and PageSize, will create the pages for you.

For example, if you set PageSize to 10, you will have 10 items from your database on each page.

Structuring into a tabular, table format can be done with simple HTML.

[txbakers]

While not EOF Loop

<tr>
<td><%= field 1%></td>
<td><%= field 2%></td>
<td><%=field 3%></td>
</tr>

Loop

Etc.

[mattur]

You may also want to google: mod +asp for an example of completing partial table rows with empty cells, using ASP's Mod function. HTH.