It seems convoluted to me, too. But, I'm having a hard time wrapping my head around what you want to accomplish. It looks like you're grouping on a non-unique field, which will of course give you multiple results. You should be doing the cfoutput group on the n_r_id field, I would think, if you want a one-per result.
On 11/3/06, daniel kessler <[EMAIL PROTECTED]> wrote: > > Is that right? It does seem convoluted so if there's a better way I'd love > to hear it. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:259002 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4