Thane: Make sure you order your SQL (using ORDER BY) based on the column(s) that you want to group.
Also, this might help: http://tutorial150.easycfm.com charlie -----Original Message----- From: Thane Sherrington [mailto:[EMAIL PROTECTED] Sent: Thursday, July 24, 2003 7:44 AM To: CF-Talk Subject: Grouping data in cfoutput I have a menu of items that looks like this: Soup du jour - cup - $1.00 Soup du jour - bowl - $2.00 Fish chowder - cup - $1.00 Fish chowder - bowl - $2.00 How can I make it display: Soup du jour - cup - $1.00 - bowl - $2.00 I tried cfoutput and grouping on the name, but that doesn't appear to work. I'm using CF5. T Tired of your bookmarks/favourites being limited to one computer? Move them to the Net! www.stuffbythane.com/webfavourites makes it easy to keep all your favourites in one place and access them from any computer that's attached to the Internet. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4