In your CFOutput, use an if statement to detect when the query record num is
odd. When it is, print a </td></tr><tr><td> to move to the next row of the
table.
Rather than
<cfoutput>
<tr>
<td>#print data#</td>
<td>#print data#</td>
</tr>
</cfoutput>
Use:
<tr><td>
<cfoutput>
#print data#</td><td>
<cfif query record num mod 2 = 1></td></tr><tr><td></cfif>
</cfoutput>
</td></tr>
A few extra table cells in there, but I'm sure its not that difficult to
clean up if you really need to.
Brian
-----Original Message-----
From: David Hannum [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 18, 2000 9:44 PM
To: CF-Talk
Subject: StartRow / MaxRow with Grouping
Hello,
I have a calendar of events that I am separating into two columns. I am
grouping by the month. I want to place half of the months that have events
(not every month has events scheduled) into the left column and the rest
into the right. How can I group the output by month, then control the
MAXROWS. Problem is, STARTROW/MAXROWS count the actual events (those are
the rows) and I do not get the distribution I want.
Thanks,
Dave
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
