i broke them up into its columns, but i still get this message ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]The text, ntext, or image data type cannot be selected as DISTINCT. -----Original Message----- From: Sicular, Alexander [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 14 November 2001 11:59 a.m. To: CF-Talk Subject: RE: SQL Query 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? | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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 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