Add sculpture_subtype as the first 'order by' in the sql.
::-----Original Message----- ::From: Melanie Tripp [mailto:[EMAIL PROTECTED] ::Sent: Thursday, April 03, 2008 7:04 PM ::To: CF-Newbie ::Subject: easy cfoutput group not working :: ::well, it's been awhile since I've had to do any cfm, but this one should ::be so easy, ::but just won't group like it's supposed to, so I must be missing ::something? :: ::Here's my query... ::<Cfquery NAME="getthumbs" DATASOURCE="#DSN#" USERNAME="#USER#" ::PASSWORD="#PASS#"> ::SELECT * ::FROM portfolio ::WHERE (sculpture_type = "Architectural") AND (Active='yes') ::ORDER BY sculpture_name DESC ::</cfquery> :: :: ::And my output code.... :: <cfoutput query="getthumbs" Group="Sculpture_SubType"> :: <div align="center"> ::<span class="pressheader">-- #GETTHUMBS.Sculpture_SubType# --</span><br> :: </div> :: <cfoutput> :: <a ::href="architectural.cfm?id=#GETTHUMBS.Sculpture_Num#"><img ::src="portfolio/#GETTHUMBS.Filename_Small#" ::border="0"></a> :: </cfoutput> :: :: </cfoutput> :: ::Here's is the live URL. ::http://glasshorsestudio.com/architectural.cfm ::It should be grouping by the categroies listed on the page, but for some ::reason, it is duplicating them. (ie Custom Accents for the Home is ::duplicated) :: ::Any help is much appreciated! Thanks! :: :: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3527 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
