Randi, that would work but it's not necessary.. what if the tables had thousands or tens of thousands of rows? Your query is pulling ALL of that data in each and every time.
On 3/19/07, Randi Knutson <[EMAIL PROTECTED]> wrote: > How about something like this: > > select P1.*, count(P2.postid) > from Posts p1, PostComments p2 > where p1.postid=p2.postid > group by p1.postid > order by p1.postdate desc > > <cfoutput query=Myquery startrow=1 endrow=5> > output here > </cfloop> > > > [email protected] on Monday, March 19, 2007 at 7:59 AM -0800 > wrote: > >> 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 Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2642 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
