|
Mailing Lists
|
Home / Groups / ColdFusion Talk (CF-Talk)
What's wrong with my <cfoutput group>?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 |
March 14, 2010
|
Latest Fusion Authority Articles
|
|||||||||||||||||||||||||||||||||||||||||||||||||