Creating a Blog Engine For Someone - CountOfReplies Question

[Will Chamberlain]

So I'm creating a blog engine for someone and am curious how to go about
creating the count (if any) of the comments for a particular post.
Underneath each post the user will have name of the poster, date, time,
and an option for replying (commenting). I would like to create a count
of replies so that it is displayed. I have a dbBlog (Access) and a table
for the entries and a table for comments. They are tied together with
primary key being id. I understand the concept of doing a rowcount for a
specific id but not for all of the posts. How could I go about doing a
count while binding the entries to the datalist?

---
"Our enemies are innovative and resourceful, and so are we. They never
stop thinking of ways to harm our country and our people, and neither do
we." President George W. Bush

*** Sent via Developersdex http://www.developersdex.com ***

[Curt_C [MVP]]

Select dbBlog.*, Count(dbComments.*) as theCount from dbBlog join dbComments
on dbBlog.blogID = dbComments.blogID.....

you get the idea

--
Curt Christianson
site: http://www.darkfalz.com
blog: http://blog.darkfalz.com

"Will Chamberlain" wrote:

So I'm creating a blog engine for someone and am curious how to go about
creating the count (if any) of the comments for a particular post.
Underneath each post the user will have name of the poster, date, time,
and an option for replying (commenting). I would like to create a count
of replies so that it is displayed. I have a dbBlog (Access) and a table
for the entries and a table for comments. They are tied together with
primary key being id. I understand the concept of doing a rowcount for a
specific id but not for all of the posts. How could I go about doing a
count while binding the entries to the datalist?

---
"Our enemies are innovative and resourceful, and so are we. They never
stop thinking of ways to harm our country and our people, and neither do
we." President George W. Bush

*** Sent via Developersdex http://www.developersdex.com ***

[Will Chamberlain]

Thanks Curt. I'll be able to try this in about half an hour but was
wondering if the output would look similar to:

ID | TOPIC | MESSAGE | ReplyCount

1 | Test Topic #1 | message #1 | 3
2 | Test Topic #2 | message #2 | 0
3 | Test Topic #3 | message #3 | 8

Thanks again for your feedback.

---
"Our enemies are innovative and resourceful, and so are we. They never
stop thinking of ways to harm our country and our people, and neither do
we." President George W. Bush

*** Sent via Developersdex http://www.developersdex.com ***