[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.
RE: [KCFusion] query output (OT)
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 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 AMTo: [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.
RE: [KCFusion] query output (OT)
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" 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 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 AMTo: [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.
RE: [KCFusion] query output (OT)
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 - #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) 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 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] query output (OT) Try this... cfquery datasource=dsn name=qry_categories SELECT Category FROMTable WHERE... /cfquery cfset listCategories = QuotedValueList(qry_categories.Category) cfloop list=listCategories index=i cfoutput #i#br /cfoutput cfquery datasource=dsn name=qry_people SELECTPerson FROMTable WHERECategory = #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. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
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=category_person ... select id, category, person from theTable order by category, person /cfquery cfoutput query=category_person group=category #Category#br cfoutput group=Person - #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) 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 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] query output (OT) Try this... cfquery datasource=dsn name=qry_categories SELECT Category FROMTable WHERE... /cfquery cfset listCategories = QuotedValueList(qry_categories.Category) cfloop list=listCategories index=i cfoutput #i#br /cfoutput cfquery datasource=dsn name=qry_people SELECTPerson FROMTable WHERECategory = #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. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] Freeze Column Headings
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 PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]