> Ok so then how would I rewrite the following if I only wanted > distinct on the 'DaCandidate' field? BUT still wanted to get > the other fields ( ie' candidate_email, ip_address, applydate ).
I think you misunderstand what DISTINCT does. It filters rows, not fields. It removes duplicate rows from your recordset. So, if you have any record which has a different set of field values from all the other records in your recordset, DISTINCT won't remove it. If you simply want to affect how things are displayed, you can ORDER BY the field or fields where you don't want to show duplicate values, then use the GROUP attribute of CFOUTPUT to display those fields once for each unique value they contain. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231462 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
