RE: [KCFusion] query output (OT)

[Kory Bakken]

Try this...   <cfquery datasource="dsn" name="qry_categories">     SELECT Category     FROM    Table     WHERE    ... </cfquery> <cfset listCategories = QuotedValueList(qry_categories.Category)> <cfloop list="listCategories" index="i"> <cfoutput>    #i#<br> </cfoutput>         <cfquery  datasource="dsn" name="qry_people">         SELECT    Person         FROM    Table         WHERE    Category = #i#         </cfquery>         <cfoutput query="qry_people">         #qry_people.Person#         </cfoutput> </cfloop> -----Original Message----- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2003 11:57 AM To: [EMAIL PROTECTED] Subject: [KCFusion] query output (OT) Is this even possible? I need to display data from a query thusly: Category1 Person1 Person2 Person3 Category2 Person1 Person2 Person3 I used the group attribute of the output tag but that only spit out 1 record. Without the group attribute I get Category1 Person1 Category1 Person2 ... Which is what I expect, just not what I need. A.