Outputting Info Selectively

[khurram]

I have a situation where I have information being display in one row across columns like this:

<TR>
<CFOUTPUT>
<TD>Employees</TD>
</CFOUTPUT>
</TR>

However, I want the output to on the next row for every three employee names. Any suggestions.

 

[Klotzki]

Hehe. I remember figuring this one myself not long ago.
The trick is to do a little bit of programming. Make your code something like this.

Hope this helps.

Klotzki

--------------------------------------------

<!--- Set Column Counter --->
<CFSET ColCount = 0>

<TR>
<CFOUTPUT>
<CFSET ColCount = ColCount + 1>
<TD>#Name#</TD>

<CFIF ColCount EQ 3>
<!--- Do this only if there are other records --->
<CFIF qryEmployees[CurrentRow] LT qryEmployees.RecordCount>
</TR>
<TR>

<!--- reset ColCount --->
<CFSET ColCount = 0>
</CFIF>

</CFIF>

</CFOUTPUT>
</TR> Klotzki