use distinct in there to only output one of each name
> >I beleive your cfoutput group should match the sort order of the > query. > > > > I added the questionid to the front of the sort order. Still no luck. > > > I did setup a valuelist so I could see what's coming straight out of > the query. It produces this: > > Clinton,Clinton,Clinton,Clinton,Clinton,Bush,Bush,Bush,Bush,Bush, > Reagan,Reagan,Reagan,Reagan,Reagan > Computers,Projectors,Chalkboard,1,2,3,4,5,1,2,3,4,5,1,2,3,4,5 > > How am I getting a cartesian join?? I've double checked my join > clauses. > > I need Clinton 1,2,3,4,5 Bush 1,2,3,4,5 > > Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274820 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4