Does anyone know of any articles/blog posts/resources on different database schemas based around using tags for categorization, maybe even (and I'm pushing it here) with a ColdFusion focus? I've got a project coming up that will involve a kind of tagging and am considering my options.
I found this article from 2005 about del.icio.us - http://www.pui.ch/phred/archives/2005/04/tags-database-schemas.html It's talking about mySQL however. We will be using SQL Server 2005, and in my dreams some smart person has created something like a database structure with a set of stored procedures for accessing and sorting. Kinda like Celko's nested tree sets. Maybe. Does anyone have any pointers? Cheers, K. -- Kay Smoljak business: www.cleverstarfish.com standards: kay.zombiecoder.com coldfusion: kay.smoljak.com personal: goatlady.wordpress.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296807 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4