erik tom wrote: > I am trying to output the table where I want to list people and their coourse > completion . and it working . The problem that I am having It outputs the > same Emp Id twice or more becaused each employee can signed up for multiple > courses. How can i do that so each employee get to show up once and get the > completion on the same row
Look at the group attribute of cfoutput. I didn't actually look at your code because it has no readable comments and there is no way this is the shortest representation of your problem. You may want to check http://www.catb.org/~esr/faqs/smart-questions.html in order to get better answers in the future. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307100 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

