But the only way to get all the dates is to select all the rows. It is meaningless to want to apply DISTINCT. If you want to display only the first occurrence of each name/address/etc., then that must be handled in display processing.
-----Original Message----- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 15, 2005 9:58 AM To: CF-Talk Subject: Re: a distinct sql problem.... the only problem is that I need that date object as well. Unless I do 2 queries and then perform some kind of checking and throw the final results into a structure. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194780 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
