>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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189332 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
