RE: Sorting for Reports

2004-06-10 Thread Pascal Peters
No he doesn't. He needs a cfoutput group=. -Original Message- From: Maureen [mailto:[EMAIL PROTECTED] Sent: donderdag 10 juni 2004 0:01 To: CF-Talk Subject: Re: Sorting for Reports You need a group by clause on your query. At 05:23 PM 6/9/04, Mickael E. wrote

Re: Sorting for Reports

2004-06-10 Thread Mickael Elmalem
: Mickael Elmalem [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 09, 2004 5:23 PM To: CF-Talk Subject: Sorting for Reports Hello All, I need to create a page that displays files(viewlets) uploaded by users, by category.The users can create categories on their own then the files get

RE: Sorting for Reports

2004-06-10 Thread Douglas.Knudsen
#foo.category# /td /tr cfoutput tr td#foo.filename#/td td#foo.othercolumn#/td /tr /cfoutput /cfoutput /table Doug -Original Message- From: Mickael Elmalem [mailto:[EMAIL PROTECTED] Sent: Thursday, June 10, 2004 5:47 AM To: CF-Talk Subject: Re: Sorting for Reports Thanks Doug

Sorting for Reports

2004-06-09 Thread Mickael Elmalem
Hello All, I need to create a page that displays files(viewlets) uploaded by users, by category.The users can create categories on their own then the files get bound to that category.I have that part working fine. My issue is the displayI have one table that has two columns, categoryID and

RE: Sorting for Reports

2004-06-09 Thread Douglas.Knudsen
[mailto:[EMAIL PROTECTED] Sent: Wednesday, June 09, 2004 5:23 PM To: CF-Talk Subject: Sorting for Reports Hello All, I need to create a page that displays files(viewlets) uploaded by users, by category.The users can create categories on their own then the files get bound to that category.I have

Re: Sorting for Reports

2004-06-09 Thread Maureen
You need a group by clause on your query. At 05:23 PM 6/9/04, Mickael E. wrote: The display issue that I am having is I would like to show the category only as a heading once then list the files associated to that category below. Then the next category as a heading then all the files