Re: group by in cfoutput

2002-10-15 Thread Sam Farmer
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

RE: group by in cfoutput

2002-10-15 Thread Dowdell, Jason G
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

RE: group by in cfoutput

2002-10-15 Thread Everett, Al
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

RE: group by in cfoutput

2002-10-15 Thread Dowdell, Jason G
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

RE: group by in cfoutput

2002-10-15 Thread Dowdell, Jason G
That's the piece I'm working on now. It won't allow you to do that since you must specify a query in order to specify maxrows. ~Jason -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 3:17 PM To: CF-Talk Subject: RE: group by in cfoutput

Re: group by in cfoutput

2002-10-15 Thread S . Isaac Dealey
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 IDNameParentIDLevel 1 Computers 0 1 2 Laptop 1 2 3

RE: group by in cfoutput

2002-10-15 Thread S . Isaac Dealey
Even if you can, I suspect it's not a very efficient method. 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

Re: group by in cfoutput

2002-10-15 Thread Jochem van Dieten
Dowdell, Jason G wrote: 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 IDNameParentIDLevel 1 Computers 0 1 2 Laptop 1