I have a products table with odd products.. Each product name exists in the table three times - they are actually seperate products seperated by the product ID and some other attributes.
I'm trying to query the DISTINCT product names to output so the site admin can assign Featured status to certain products. product1: (checked) product2: (checked) product3: (checked) product8: () product9: () etc Selecting distinct names is no problem without the Featured column. Once something is flagged, another instance of the same item is selected - because the row is no longer distinct. product1: (checked) product2: (checked) product3: (checked) product8: () product9: () product1: () <--- product2: () <--- etc Any ideas? I really don't want to normalize the table any further - the products don't necessarily have to have the same names - they just usually do - and can be changed at any time. TIA! Jeff Beer Director of Application Development Digital Stormfront, Inc http://www.digitalstormfront.com <http://www.digitalstormfront.com> ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
