Hey all, Here is my simple use case: I have a table of articles. I would like to indicates some as featured.
Here is my dilemma: Since only a few rows in the table will be featured articles I figured it would be bad to have an "isfeatured" field in the table. Why have a field for every row when a small minority will actually use it? My thought was to create a second table with all of the featured article id's. However, should I really create a table with one field just for maintaining a list of article id's? What would be the "best" approach? Thanks, Aaron ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290712 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

