<cfset midPnt = MyQuery.recordcount/2>
<cfset col2startRow = #midPnt#+1>
<table width=100>
<td width=50 >
<cfoutput query="MyQuery" startrow="1" maxrows="#midPnt#">
#MyQuery.variable#<br>
</cfoutput>
</td>
<td width=50 >
<cfoutput query="MyQuery" startrow="#col2startRow#"
maxrows="#midPnt#">
#MyQuery.variable#<br>
</cfoutput>
</td>
</table>
here is a start, you made have to check for an odd-numbered recordcount and
its affect on the output
----- Original Message -----
From: "Erik Yowell" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, June 18, 2002 1:11 PM
Subject: Query to Multiple Horizontal Columns (ordered vertically)
> Perhaps I haven't had enough coffee this morning. But I'm having the
> darnedest time wrapping my head around this one (or maybe I just got to
> the point of abstracting this one a little too much in my head):
>
>
>
> I have say (4-5) queries of variable record count and would like to
> split the results into two columns (ordered vertically, not
> horizontally), also breaking at the logical "half point". For instance:
>
>
>
> 1 5
>
> 2 6
>
> 3 7
>
> 4 8
>
>
>
> Any recommendations or resources anyone could point me to?
>
>
>
> Erik Yowell
>
> mailto:[EMAIL PROTECTED]
>
> Short Fuse Media, Inc.
>
> http://www.shortfusemedia.com <http://www.shortfusemedia.com/>
>
>
>
>
>
>
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
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
