This is what I use most of the time for dynamic tables. Let me know if this
helps.
<cfset count = 1>
<table width="550" align="center">
<tr>
<td>Customer Name</td>
<td>Phone</td>
<td>Customer Name</td>
<td>Phone</td>
</tr>
<cfoutput query="[query name]">
<cfif count MOD 2>
<tr>
</cfif>
<td width="125">#custName#</td>
<td width="125">#custPhone#</td>
<cfif NOT count MOD 2>
</tr>
</cfif>
<cfset count = count + 1>
</cfoutput>
</table>
__________________________
Lee Brandt
Owner
Atlantic Technical Design
http://www.atechdesign.com
[EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Bryan LaPlante
Sent: Monday, August 28, 2000 1:27 PM
To: [EMAIL PROTECTED]
Subject: Re: [KCFusion] Output in Newspaper style format
didn't realize you wanted it in two columns. what if you use the startrow
and maxrows from the cfoutput tag and set the number of results per column.
----- Original Message -----
From: "Chris" <[EMAIL PROTECTED]>
To: "KCFusion-List" <[EMAIL PROTECTED]>
Sent: Monday, August 28, 2000 12:46 PM
Subject: [KCFusion] Output in Newspaper style format
>
> Is there an easy way to do the following?
>
> My select statement is SELECT cust_name, cust_phone
> FROM customer ORDER BY cust_name.
>
> I want my output to be like this.
>
> Customer Phone Customer Phone
> John Doe 111.111.1111 Joe Smith
> 222.222.2222
> Alice Wilson 333.333.3333 Paul Wilson
> 444.444.4444
>
> What I've got now is the customer/phone list coming
> out in 1 column in a table. Is it possible to do it
> in two in ColdFusion? I think I can do this in SQL,
> but I'd rather have CF handle it if I can.
>
> Thanks,
>
> Chris
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/
>
>
> ______________________________________________________________________
> The KCFusion.org list and website is hosted by Humankind Systems, Inc.
> List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org
> Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
> To Subscribe.................... mailto:[EMAIL PROTECTED]
> To Unsubscribe................ mailto:[EMAIL PROTECTED]
>
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
