there isnt some whifty nifty whizbang thing from .net 4 that? ---------- Original Message ---------------------------------- From: Will Tomlinson <[EMAIL PROTECTED]> Reply-To: [email protected] Date: Tue, 04 Jan 2005 21:46:11 -0400
>>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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189466 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
