I don't recall ever having a problem with the <cfoutput> group attribute. But I can't figure out why it isn't woring right here.
My table looks like this: ID Date ZIP code --------------------------------- 1 12/01/2008 27403 2 12/01/2008 90210 3 12/01/2008 45789 4 12/01/2008 27403 5 12/02/2008 55555 6 12/02/2008 21454 A simple query: <cfquery name="getshipcalclog" datasource="#APPLICATION.settings.dsn#"> SELECT estshiplogid, estshiplogdate, estshippostalcode FROM tblestshiplog ORDER BY estshiplogdate DESC </cfquery> Now, I just want to output the records grouped by the date. So there should be a date heading, and all the zip codes with records on that date. <cfoutput query="getshipcalclog" group="estshiplogdate"> <h3>#estshiplogdate#</h3> <cfoutput> <p>#estshippostalcode#</p> </cfoutput> </cfoutput> But it outputs every occurence of 12/01/2008 and its zip. When it should display 12/01/2008 as a heading, then fours zips below it. Then start another heading 12/02/2008, and two zips below that. What am I doin wrong here? Thanks! Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316091 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
