Try breaking up the Highlights.* into its columns.
Good luck,
Alexander Sicular
Chief Technology Architect
Neurological Institute of New York
Columbia University
as867 [at] columbia {dot} edu
|-----Original Message-----
|From: Nick Le Mouton [mailto:[EMAIL PROTECTED]]
|Sent: Tuesday, November 13, 2001 5:51 PM
|To: CF-Talk
|Subject: SQL Query
|
|
|SELECT DISTINCT highlightDates.highlightID,
|HighlightDates.HighlightDate,
|Highlights.*
|FROM Highlights, HighlightDates
|WHERE HighlightDates.HighlightDate >= #startweek# AND
|HighlightDates.highlightdate <= #DateAdd('ww', 1, startweek)#
|AND Highlights.HighlightID = HighLightDates.HighlightID AND
|Highlights.Status = 1
|
|Can some one tell me why the query above doesn't work
|I thought it would only look at highlightDates.highlightID and
|select a distinct one of those, but it seems to be trying to
|do a distinct over all of the selected fields
|
|help! how can i make it select a distinct highlightID?
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
