I am a junior-ish developer interested in building a number of content management tools for some of my clients using ASP VBScript and SQL Server 2000 (shared hosting environments).
Ideally, I want to build an easily customizable and extensible framework of fairly standard database-driven elements:
* news items
* resource/link lists
* email subscription and management
* item/content rating system
* page/content management with dynamic navigation elements
I'm looking for guidance, review, sample code help from an experienced developer who can articulate why her/his strategy is best and help me through some of the more complex issues surrounding database design, SQL queries, and code architecture.
possibly database schema
completed SQL queries
code examples as needed
ASP VB Script
SQL Server 2000
Limited use of 3rd party ASP Components
Should work in 4.0 browsers on Windows