Output new row after 3 records 2

[dv8er88]

Hello want to loop through a query and output a new row after 3 records.

Thanks D

<table width="95%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td>record 1</td>
<td>record 3</td>
<td>record 3</td>
</tr>
<tr>
<td>record 4</td>
<td>record 5</td>
<td>record 6</td>
</tr>
<tr>
<td>record 7</td>
<td>record 8</td>
<td>record 9</td>
</tr>
</table>

 

[overmodulation]

<cfset i = 0 />

<table rules="all" border="1">
	<cfoutput query="myQuery" startrow="#i+1#">
		
		<cfif i MOD 3 IS 0>
			<tr>
		</cfif>
		
		<td>#myRecord#</td>
		<cfset i = i+1 />
		
		<cfif i MOD 3 IS 0>
			</tr>
		</cfif>
		
	</cfoutput>
</table>

 

[overmodulation]

One minor change to that ... the <cfif> statement that closes out the row should have another condition in case the query loop is over like so:

<cfif i MOD 3 EQ 0 OR i EQ myQuery.RecordCount>
 </tr>
</cfif

 

[imstillatwork]

don't forget to fill in any missing cells if you want valid html...


I do it like this

http://www.lot-o-nothin.com/cfml/tutorials/index.cfm/id/6_8/

enjoy.

Kevin

http://www.lot-o-nothin.com/cfml/

 

[overmodulation]

yeah that works too.

I just threw that code together spur of the moment.

 

[dv8er88]

Thanks to you both. It works great