What is the sql you have now? -----Original Message----- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 04, 2005 8:46 PM 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189366 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
