I'm going totally crazy! I have a blog and I want people to be able to post comments and have those comments appear at the bottom of each blog entry. I know this isn't that uncommon...you see it all over the web. But I can't figure out how to get DW to do it.

I have the tables built successfully (as far as I can tell anyway). The blog is working great, it displays the entries in order. But as soon as I add a second recordset I get errors. The one record set I have holds only the entries for the blog, which contains three fields (id, date, and entry). I THINK I need to create a second record set that holds an inner join on the field date so that all the (future) comments appear on the corresponding page. I hope that makes sense.

My code is too long to post here. But I will try. You can see what I am trying to do at www.CraigGreenwood.com and then click Journal. Also here is a link to a text file that contains the code as well:

www.craiggreenwood.com/journalcode.txt

Please help!

Craig