Oh, yeah, you're right...that would do exactly what I want. I guess I was just too close to the problem to see it. Thanks Mike.
> -----Original Message----- > From: Michael Wilson [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, December 06, 2001 6:23 PM > To: SQL > Subject: RE: GROUP BY clauses > > 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. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
