Alternate Row Colors in ASP Query Results

Adding VBScript to ASP page to alternate row colors in FrontPage Database Results Wizard query results

VBScript can be added to a page created by the Database Results Wizard to alternate the row colors when displaying data.

In HTML View add the five lines below the <body> tag.

<% strOddColor = "bgcolor='#FFFFFF'" strEvenColor = "bgcolor='#C0C0C0'" intLineNum = 0 %>

Change the bgcolor values to suite your needs.

Locate the Database Results Wizard tag that looks similar to the following.

Just below the Database Results Wizard tag is the first line of the table that start with a <tr> tag.

Add the following just below Database Results Wizard tag and before the <tr> tag.

<% intLineNum = intLineNum + 1 If intLineNum Mod 2 = 0 Then strLineColor = strEvenColor Else strLineColor = strOddColor End If %>

Edit the <tr> so it looks like the following.

Save the page and test it in the browser.