Hi, I'm not sure but are you looking for ORDER BY rather than GROUP BY...?
SELECT ConferenceID, Sponsor, SponsorType, ImgName, URL_Link FROM Conf_Sponsors WHERE ConferenceID = '#url.id#' ORDER BY SponsorType This would return the SponsorType Ordered, I Think, Ascending by default. E.g. SponsorType1 SponsorType2 SponsorType3 You could change this to ORDER BY SponsorType DESC for the reverse order. Regards, Mike > -----Original Message----- > From: Cottell, Matthew [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 06, 2001 5:21 PM > To: SQL > Subject: RE: GROUP BY clauses > > > Yes, I know about the group attribute of cfoutput. > But I need the output in a specific order and I thought if I > could group in SQL, > I could write some CF code to display it the way I needed it. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
