I am very new to ASP and have been taught by one of my colleagues that I could leverage Dreamweaver (i have version 8) to create ASPx pages that collaborate with Microsoft Access -- to implement a webpage that displays, as I would like to call it, news snippets -- this is relatively easy thing to do.
Now comes the problem of segregation: I need to start separating each individual news snippets. Why? Each news snippet will have a functionality where users can leave comments on that particular news snippet.
I believe blogs have this kind of functionality.
In my MS Access database, there are 2 tables. Here's the tables and their columns.
news_id (autonumber, primary key)
belonging_to_id (foreign key, value populated automatically as users submit comments via the front-end ASP page)
When I look at Dreamweaver's generated code, it seems likely that I could start a dataset by writing a block of code (forgot how it looks like) with the corresponding SQL code injected inside this block of code.
I am trying to
1. Display the news snippets (think this part is ok for me)
2. Display the user's comments below each and every news snippet
3. Count the number of comments per news snippet
Should I use SQL and its "Count" and "Where" functionality to do #2 and #3? Or must I use VB?