I am using mySQL
>Also what DB are you using, the get 5 latest part will be DB >specific.. in Oracle, we can get the rownum. Something like this... > >select * >from ( >select p.post, count(pc.*), rownum as rn >from posts p >right outer join post_comments pc on pc.postid = post.postid >group by p.post >) where rn <= 5 > >On 3/19/07, Nathan Chen <[EMAIL PROTECTED]> wrote: >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2647 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
