I have two tables, Posts and PostComments, the latter of which has a foreign key on the PostID of Posts.
On my output page, I am using an output query to display the latest 5 Posts. Inside of this output query, I need to show how many comments are related to the particular posts. I have tried a million combinations of joins and attempts at some loops, but I cannot figure this out. All that I have been able to manage so far is to either show the same number for each post, or to show a descending number of all totals for each post. Moreover, my brain is nearly fried from frustration. This seems like it should be incredibly simple, but I am at a complete loss. Anyone have any ideas? Thanks! Joel ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2637 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
