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]
 

Reply via email to