asked on

Repeat <thead> every 10 rows...SQL 2000 / ASP

I would like to repeat the column heading every 10 rows on the results page of a SQL 2000 query. Does anyone have experience with this?

Here is my HEADER ROW...

<thead>
<tr>
<td bgcolor="#000080"><font color="#FFFFFF" size="1" face="Arial">
<b>ID</b></font></td>
<td bgcolor="#000080"><b>
<font face="Arial" size="1" color="#FFFFFF">EDIT</font></b></td>
<td bgcolor="#000080"><font color="#FFFFFF" size="1" face="Arial">
<b>Last Name</b></font></td>
<td bgcolor="#000080"><font color="#FFFFFF" size="1" face="Arial">
<b>First Name</b></font></td>
</tr>
</thead>
Thanks!!

ASKER CERTIFIED SOLUTION

CRagsdell

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

CRagsdell

Ooops, take out the </thead> tag in the details line...

and there is a typo in "If left out the rest..."

It should read "I left out the rest..."

CR

jvescio

ASKER

Thanks for responding,

Are you saying this code replaces my current query completely? If so, where would code reside? Above the head tag? In the body?

JV

CRagsdell

Use your current query, as this was just an example of how the looping and counting of 10 lines between each <thead></thead> would work.

Just noticed, you might have to replace the "If strCounter <> 10 Then" line with "If strCounter <> 9 Then" since I am resetting to 0 after each 10 records.

Run the query anywhere on your page prior to where you want to show the results. Where you are now showing the results, use my sample (revised as necessary to meet your needs) to build the parts of the table where you want the header to repeat.

CR

substand

what language are you using?

jvescio

ASKER

I am using ASP and SQL Server 2000.

I am editin code generated by Frontpage 2002.

Here is an example:

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
</head>

<body>

<table width="100%" border="1">
<thead>
<tr>
<td><b>ID</b></td>
<td><b>lastname</b></td>
<td><b>firstname</b></td>
<td><b>pw</b></td>
<td><b>username</b></td>
<td><b>dept</b></td>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM employees"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="employees"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=6
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>


<tr>
<td>
<%=FP_FieldVal(fp_rs,"ID")%></td>
<td>
<%=FP_FieldVal(fp_rs,"lastname")%></td>
<td>
<%=FP_FieldVal(fp_rs,"firstname")%></td>
<td>
<%=FP_FieldVal(fp_rs,"pw")%></td>
<td>
<%=FP_FieldVal(fp_rs,"username")%></td>
<td>
<%=FP_FieldVal(fp_rs,"dept")%></td>
</tr>

</tbody>
</table>

</body>

</html>

CleanupPing

jvescio:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.

monosodiumg

No comment has been added to this question in more than 245 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
Accept: CRagsdell http:#8083445

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

monosodiumg
EE Cleanup Volunteer

Repeat &lt;thead&gt; every 10 rows...SQL 2000 / ASP

Repeat <thead> every 10 rows...SQL 2000 / ASP