This allows for an undetermined about of columns returned by the query. I
didn't test it, so something may be a bit off, but I'm sure you get the
point.
<cfset rowLen1 = val(foo.recordCount / 2)>
<cfset rowLen2 = foo.recordCount - rowLen1>
<table>
<tr>
<td>
<table>
<cfoutput query="foo" maxrows="#rowLen#">
<tr>
<td>#foo.column1#</td>
</tr>
</cfoutput>
</table>
</td>
<td>
<table>
<cfoutput query="foo" startrow="#rowLen2">
<tr>
<td>#foo.column1#</td>
</tr>
</cfoutput>
</table>
</td>
</tr>
</table>
jon
----- Original Message -----
From: "Douglas Brown" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 7:09 PM
Subject: Outputting query results side by side A-Z
> I want to output query results side by side and A-Z
>
> IE:
> First column Second Column
> A G
> B H
> C I
> D J
> E K
> F L
>
> Any ideas?
>
>
>
> There are two major products that come out of Berkeley: LSD and [Unix]
> BSD. We don't believe this to be a coincidence.
>
>
>
> Doug Brown
>
______________________________________________________________________
Dedicated Windows 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=coldfusiona
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
