Try this:
<cfscript>
col1start=1;
col1max=RecordCount \ 2 + RecordCount MOD 2;
col2start = col1start + col1max;
col2max = RecordCount \ 2;
</cfscript>
<table>
<tr>
<td>
<table>
<cfoutput query="queryname" startrow="#col1start#" maxrows="#col1max#">
...
</cfoutput>
</table>
</td>
<td>
<table>
<cfoutput query="queryname" startrow="#col2start#" maxrows="#col2max#">
...
</cfoutput>
</table>
</td>
</tr>
</table>
> -----Original Message-----
> From: Phillip Perry [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 25, 2002 1:48 PM
> To: CF-Talk
> Subject: Showing DB output in html tables.
>
>
> Hi,
>
> I have 5 columns in a access db. Fist name, last name, wins,
> loses, rating.
> I want to break this list into 2 html table columns..
> something like the
> following...
>
> Name Wins Loses Rating Name Wins
> Loses Ratings
>
>
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
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
