I believe I need all those columns and more. The grouping on cfoutput didn't work, I suppose, cause there's unique data in each record and none of them are truly the same. That's why there's 4 records to begin.
I suppose I could do three seperate queries and that would work for this case. Each query will have just the fields that apply to the unique data. I had hoped to work off of one dataset. Even then, I would have to do the query three times just to sort the data three different ways (by each type of ID). Right? At some point, to do reports, I'll have to work off of one dataset and sort it a number of ways, loop through it, checking that the ID isn't the same as the previous ID and then do whatever with the data. Is that right? It does seem convoluted so if there's a better way I'd love to hear it. >How many of the columns are needed? If you only need a fw of the columns, >remove the extra columns and then loop over them regularily. If you want to >group them, then use the group attribute in cfoutput, which isn't all that >cumbersome at all. If you have duplicates, just make sure to use the >keyword "distinct" after "select" to remove them. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258991 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
