There are several ways to do what you want, the easiest imo below.
Now try thinking about 3 columns of data going vertical with
subcategories...ouch, I hated that site ;-)

<cfset startrow = 1>
<cfset displaycols = 2>

<cfquery name="stuff" ... >
SELECT Items
....
</cfquery>

<table>
<cfloop query="stuff">
<tr>
<cfoutput query="stuff" maxrows="#displaycols#" startrow="#start_row#">
<td>#Items#</td>
</cfoutput>
<cfset start_row = startrow + displaycols>
</tr>
</cfloop>
</table>

jon

----- Original Message -----
From: "Barney Stevenson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, December 22, 2000 9:31 PM
Subject: Displaying Query Results in Two or More Columns


> There is probably a really obvious answer to this, but I can't work out
> how to display records in multiple columns.
>
> I want to achieve something like this:
>
> <tr><td>record 1</td><td>record 2</td></tr>
> <tr><td>record 3</td><td>record 4</td></tr>
> <tr><td>record 5</td><td>record 6</td></tr>
> etc.
>
> So that my query results are displayed in balanced columns.
>
> Any ideas?
>
> Regards
>
> Barney
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to