Output Every X Rows

[hml398]

I need to be able to mark every 25th row of my table with a special color. It is Monday and my brain doesn't seem to be working. I know this is simple but I can't remember how to do this./ Any help would be appreciated.

[Newsgroup_User]

<cfif rowCount MOD 25 EQ 0><!-- Change row color ---></cfif>

[Pete_L_]

I think you can just set the bg color of the table cell like so:

bgcolor="###IIF(yourQueryName.CurrentRow MOD 25, DE("FF0000"), DE("FFFFFF"))#"

The extra pound signs at the beginning make sure your final output is something like "#FFFFFF" instead of just "FFFFFF" -- this matters in some browsers, i.e. Firefox.

[Sojovi]

<CFIF Query_Name.RecordCount MOD 25 EQ 0>
Change color. . . . . .
</CFIF>

Regards

[Sojovi]

Oops...Query_Name.CurrentRow is the correct expression.