Can you provide a simple example recordset that your query might generate? Something like this?
id,name,clubId,club,category 1,barney,1,a_club,road work 1,barney,1,a_club,gardening 1,barney,2,b_club,road work 1,barney,2,b_club,gardening cheers, barneyb On 7/26/05, Tim Laureska <[EMAIL PROTECTED]> wrote: > I have a query that pulls member information, including typical info > such a name, address, etc - each member can belong to one or more clubs > and can also be in one or more volunteer capacities > > There are 5 tables: > Members - basic member info > Clubs - list of clubs > Volunteer categories - list of volunteer categories > Volunteer inking table - links member id to one or more volunteer > categories > Club linking table - links member id to one or more volunteer categories > > Grouping by clubs OR Grouping by volunteer categories is not problem > using the group="club" for example within the cfoutput tag. The > challenge comes in when I the want the volunteer category to also be > displayed for each member.. > > I've tried this, but it outputs the volunteer and club categories twice > for each member: > > <table border="1"> > <cfoutput query="get_members" group="member_id"> > <tr> > <td>#member_id#</td> > <td>#fname# #lname#</td> > <td><cfoutput>#club# (#club_id#)<br></cfoutput></td> > <td><cfoutput> volunteer > category:#category#<br></cfoutput></td> > </tr> > </cfoutput> > </table> > > > any suggestions would be appreciated > > Tim > > > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212838 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
