I'm just going through a bunch of old posts, so sorry if this was answered already.
DISTINCT acts on the whole select list. So all of prodID, prodmodelcode, prodtitle, prodcategory, prodsellprice have to be distinct for you to get the results you want. Ade -----Original Message----- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: 05 January 2005 01:46 To: CF-Talk Subject: Re: SQL group by instead of cfoutput group? >Just add 'DISTINCT' after 'SELECT' and SQL Server will automatically >ensure that you don't have any duplicate rows in your result set. Oh, >and go check out CFQUERYPARAM and use it. It'll save you lots of >headaches. I tried DISTINCT and it still returns duplicate prodmodelcodes. How can I weed out those duplicate model codes? hmmmm.... I'll be using a stored procedure for it so security will be covered. Thanks for your help, Will -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.2 - Release Date: 21/01/2005 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware: 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:191478 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
