The result set should come out in the order it was selected
in the alphabetic order of the order by clause.
Format your output like so
<table>
<tr>
<td>Name</td>
<td>Phone</td>
</tr>
<CFOUTPUT QUERY="resultName">
<tr>
<td>#cust_name#</td>
<td>#cust_phone#</td>
</tr>
</CFOUTPUT>
</table>
----- 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]