A query is a struct of arrays so you can just loop through.
for example
<cfscript>
writeoutout("<table>");
cols=2;
rowspercol=ceiling(q.recordcount/cols);
for(i=1;i le rowspercol;i=i +1){
writeoutput("<tr>");
for(j=1; j le cols; j= j+1){
k= (j-1)*cols+i;
writeoutput("<td>");
if(k LE q.recordcount) writeoutput(q.myfield[k]);
else writeoutput(" ");
writeoutput("</td>");
}
writeoutput("</tr>");
}
writeoutout("</table>");
</cfscript>
----- Original Message -----
From: "Douglas Brown" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 5: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
