Can you put maxrows="3" in the innermost CFOUTPUT?
> -----Original Message-----
> From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 15, 2002 3:15 PM
> To: CF-Talk
> Subject: RE: group by in cfoutput
>
>
> It does a portion of what I want. I need to restrict
> the output of the group by to a max of 3 records per
> parent category.
>
> ~jason
>
> -----Original Message-----
> From: Sam Farmer [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 15, 2002 3:11 PM
> To: CF-Talk
> Subject: Re: group by in cfoutput
>
>
> look at the group attribute of cfoutput.
>
> Should do what you want.
>
> HTH,
>
> Sam
>
>
> ----- Original Message -----
> From: "Dowdell, Jason G" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, October 15, 2002 2:30 PM
> Subject: group by in cfoutput
>
>
> > Hi all,
> >
> > Here's a bit of a challenge. I have a single table storing category
> > information similar to any search engine. The table structure looks
> > like this
> > ID Name ParentID Level
> > 1 Computers 0 1
> > 2 Laptop 1 2
> > 3 Desktop 1 2
> >
> > Since I have to display this information I must join the
> table back to
> > itself. All joining has gone fine :) My problem is in the
> display of the
> > information to the users. I want to display the Parent category
> > and then only 3 children from each category. Sounds easy but
> > I'm not sure if I can do this in sql or not. If sql could
> accomplish
> > this then super, if not then it's a good CF challenge.
> >
> > Any ideas?
> >
> >
> > -------------------------------------------------
> > Jason Dowdell
> > IM-AES Web Developer
> > 321.799.6845
> > [EMAIL PROTECTED]
> > -------------------------------------------------
> >
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
