cfloop with tables

[Dani Szwarc]

Hello guys. I'm trying to generate a table with results from a query. I'm using cfloop to generate this. With on result per row works ok. I'm a bit lost on how to generate the same table but showing 3 results per row instead of one. I guess I have to use nested cfloop, but how?

Any help will be highly appreciated.\

Thanks a lot.

Dani

[jbreslow]

Hi DaniFW,

This should give you three columns per row...

<cfoutput>
<table border="1">
<tr>
<cfloop query="qSelect">
<td>#qSelect.currentRow#</td>
<cfif qSelect.currentRow MOD 3 EQ 0>
</tr><tr>
</cfif>
</cfloop>
</tr>
</table>
</cfoutput>

[Dani Szwarc]

Great!!!! Thanks so much Josh!!!!