Here ya go:
<CFSET COLUMNCOUNT = 3>
<DIV ALIGN="center"><TABLE WIDTH="600" BORDER="0" BORDERCOLOR="White"
CELLPADDING="1" CELLSPACING="2"><TR BGCOLOR="ffcc66">
<CFOUTPUT QUERY="GetHeadingsFirstLetter" STARTROW="#attributes.start#"
MAXROWS=#MAXROWS#>
<TD><FONT FACE="Arial" SIZE=-2><CFIF PAGES EQ "C"><A
HREF="/HL/SHL/index.cfm/HD.#Class_ID#/AL.#attributes.alpha#">#Class_Name#</A>
<CFELSE><A
HREF="/HL/LL/index.cfm/HD.#Class_ID#/AL.#attributes.alpha#">#Class_Name#</A> </CFIF></FONT></TD>
<CFIF CURRENTROW MOD COLUMNCOUNT EQ 0>
</TR>
<CFIF CURRENTROW NEQ MAXROWS>
<TR BGCOLOR="#IIf(CurrentRow Mod 6, DE('ffffff'), DE('ffcc66'))#">
</CFIF>
<CFELSEIF CURRENTROW EQ MAXROWS>
<CFLOOP FROM="#Evaluate(columncount-(currentrow MOD
columncount))#" TO="1" STEP="-1" INDEX="i">
<TD></TD>
</CFLOOP>
</TR>
</CFIF>
</CFOUTPUT>
</TABLE></DIV>
Set MAXROWS equal to an even multiple of 3 (that is, 96 not 99) to get the
correct alternating row color from one page to the NEXT page.
best, paul
At 05:12 PM 9/1/00 +1100, you wrote:
>I want to display the results of my query in 3 columns instead of one. I
>know the method is something to do with mod3, but I'm dashed if i can
>figure it out.
>
>What I want to get is:
>
>[record1] [record2] [record3]
>[record4] [record5] [record6]
>etc
>
>Can anyone help me please with how to code it?
>
>Cheers,
>Mike Kear
>AFP Web Development
>Windsor, NSW, Australia
>
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
