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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:212814
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
