Ahh! Voila! Thank you. Just had to add a little (to accommodate the odds):
<cfset midPnt = Ceiling(MyQyery.recordcount/2)> Works like a charm, much thanks. -Erik -----Original Message----- From: Charlie [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 1:21 PM To: CF-Talk Subject: Re: Query to Multiple Horizontal Columns (ordered vertically) <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/> > > > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
