Sean,
>
> I have a table, that is grouped by a column called "displayname".
> I want to
> have the repeating data in columns of 2. Normally I would do this using
> startrow and maxrows. However inside of a nested cfoutput it appears you
> cannot do that.
Its at this point I go back to the old fashioned way of processing groups -
loops where you store the previous group and check to see whether this is a
new group or not.
I guess you'd do something like this :
<cfset prevgroup = "">
<table width=485>
<cfoutput query="our_people2">
<!--- Here's your group header across 2 columns --->
<cfif DisplayGroup NEQ PrevGroup>
<tr>
<td colspan=2>
<font face="verdana, helvetica" color=##737373 Size=3>
<i><b>#trim(displayGroup)#</b></i>
</font>
</td>
</tr>
<cfset prevgroup = displaygroup>
</cfif>
<cfif NOT (recordcount MOD 2)>
<!--- Start a new TR if you've got an odd number --->
<tr>
</cfif>
<td>
<IMG alt="" border=0 height=221
src="../images/prof/people/#trim(personPicFileLocation)#.jpg" width=178>
<br>
<FONT face="verdana, helvetica" color=##737373 size=3>
<STRONG>#trim(personDisplayName)# <cfif
isdefined("personDegree")>,#trim(personDegree)#</cfif>
</strong>
</FONT>
</td>
<cfif (recordcount MOD 2)>
<!--- End the TR if you've got an even number --->
</tr>
</cfif>
</cfoutput>
</table>
I may not have it quite right, but give it a go - see what happens.
I have a feeling I may have mixed up the conditions for starting and ending
a TR...
Regards
Stephen
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
