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=&quo
- #Person#br
/cfoutput
/cfoutput
The other suggestion is going to produce bunch of un-necessary queries.
-Original Message-
From: Kory Bakken [mailto:[EMAIL PROTECTED]
Sent: Friday, March 28, 2003 12:59 PM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] query output (OT
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 name