Traci,
For the recordset that you already have.
Pipe_id File_id File_title
=====================================
98991 0 proposalrevision.doc
98991 0 tableofcontents.doc
98991 1 visio.vsd
98991 2 08fmla.doc
92874 0 allergies.ppt
87171 1 statementofwork.doc
45663 2 debrief0999.pdf
You can just output it like so, without grouping in the query itself.
<cfoutput query="MyQry" group="Pipe_id">
#MyQry.Pipe_id#<br /> <!--- This will display once. --->
<cfoutput>
#MyQry.File_title#<br /> <!--- This will display all the
documents associated to the Pipe_id --->
</cfoutput>
</cfoutput>
HTH
Chuck
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326246
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
