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
Try
this...
cfquery datasource="dsn"
name="qry_categories"
SELECTCategory
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
Sorry,
you need to make sure that the qry_categories specifies a DISTINCT
category.
-Original Message-From: Kory Bakken Sent:
Friday, March 28, 2003 12:56 PMTo:
[EMAIL PROTECTED]Subject: RE: [KCFusion] query output
(OT)
Try
this...
cfquery datasource="dsn"
Krisi almost had it... this will do the trick.
cfquery name=category_person ...
select id, category, person
from theTable
order by category, person
/cfquery
cfoutput query=category_person group=category
#Category#br
cfoutput group=Person
-
SWEET! Thanks all three of you. Justin finally nailed it.
A.
- Original Message -
From: Justin Hansen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 28, 2003 1:35 PM
Subject: RE: [KCFusion] query output (OT)
Krisi almost had it... this will do the trick.
cfquery
Is there a way to freeze the column headings and scroll the rest of the
table?
Jamie
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/[EMAIL