here is what I use, I think I actually got this via help from this wonderful
list a few months ago :-)
first set the columns to have...
<cfset ColumnCount=3>
run your query... lets use qMyQuery as an example name
then your output...
<table bgcolor="FFFFFF" cellspacing="0" cellpadding="1" border="0"
align="center" width="100%">
<tr>
<cfoutput query="qMyQuery">
<cfif (qMyQuery.CurrentRow GT ColumnCount) AND (qMyQuery.CurrentRow mod
ColumnCount is 1)>
</tr><tr>
</cfif>
<td align="center" valign="top">
...content to be displayed...
</td>
</cfoutput>
<!---For Netscape, fill any remaining cells with a "hard space"--->
<cfif qMyQuery.RecordCount mod ColumnCount GT 0>
<cfloop from=1 to=#Evaluate(ColumnCount-(qMyQuery.RecordCount mod
ColumnCount))# index=index>
<td> </td>
</cfloop>
</cfif>
</tr>
</table>
______________________________________________________________________
Why Share?
Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists