It's a unique field. It's the ID field of the "attendees" table, which relates to the "notes" or the base table. But since the other fields don't all have the same data from there, I suppose it can't logically group. For example, they might each have different values in the take_aways field. I queried on the n_r_id field so they all have the same number there.
> It seems convoluted to me, too. But, I'm having a hard time wrapping > my head around what you want to accomplish. It looks like you're > grouping on a non-unique field, which will of course give you > multiple > results. You should be doing the cfoutput group on the n_r_id field, > I would think, if you want a one-per result. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259023 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
