>>Also on Line 77, the CFOUTPUT should *not* contain the GROUP attribute because it's >>>being used to populate a select, not display output by group.
Oops! My statement above is incorrect. In this case, the GROUP attribute in the CFOUTPUT behaves like SQL's DISTINCT function. It's not only OK to use, it's necessary to return the correct results. My apologies for any confusion this may have caused. ~Dina ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4