You can reference the query by bracket syntax and do a nested loop as such:
<!--- Query name = qResults --->
<cfset cols = 4>
<cfset rows = Int(qResults.Recordcount/4)+1>
<cfloop from="1" to="#rows#" index="i">
<tr>
<cfloop from="1" to="#cols#" index="j">
<cfset currentIndex = i + ((j-1)*rows)>
<cfif currentIndex gt qResults.Recordcount>
<td> </td>
<cfelse>
<td>#qResults.fieldName[currentIndex]#</td>
</cfif>
</cfloop>
</tr>
</cfloop>
NOTE, that code is not tested. It's just give you the idea/theory behind
it. I hope that makes sense.
Ben Johnson
Hostworks, Inc.
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
