> -----Original Message----- > From: daniel kessler [mailto:[EMAIL PROTECTED]
> I have not and didn't know that - thanks for the information. > In that case, for three orderings, I'd need to do three > queries, right? > > >You know, you might have an ordering issue. The cf group by needs the > >query to be ordered by whatever you're grouping by for it to work > >correctly. Have you tried ordering it by that id? Deanna, is right. The data in the query needs to be ordered in the way you want it output for the group attribute of cfquery to work correctly. If you want it ordered by last name, for example, you'll need to do this in your order by clause: ORDER BY Lname, Fname, N_R_Attendees_ID You should then be able to use your current cfoutput code with the query. Andy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:259044 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
