So I have a query that returns the following..
Client_Code MenuName Client_Name
4938 Test Test Company
9328 Test Test Company
10349 Test Test Company
9283 Test Test 2 Company
What I'm trying to do is produce a table for
MenuName Client_Name Client_Code
Test Test Company 4938,9328,10349
Test Test 2 Company 9283
So far, I have this..
<cfoutput query="currentQuery" group="Client_Code">
<tr>
<cfloop list="#event.getArg("displayList")#"
index="currentField">
<td>
#currentQuery[currentField][currentQuery.currentRow]#
</td>
</cfloop>
</tr>
</cfoutput>
Which is showing each client_code on a seperate line..
Can someone tell me what I'm doing wrong here?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352844
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
