[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]
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. select id, category, person from theTable order by category, person #Category# - #Person# 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... SELECT Category FROMTable WHERE... #i# SELECTPerson FROMTable WHERECategory = #i# #qry_people.Person# -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]
RE: [KCFusion] query output (OT)
Krisi almost had it... this will do the trick. select id, category, person from theTable order by category, person #Category# - #Person# 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... SELECT Category FROMTable WHERE... #i# SELECTPerson FROMTable WHERECategory = #i# #qry_people.Person# -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)
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... SELECT Category FROM Table WHERE ... #i# SELECT Person FROM Table WHERE Category = #i# #qry_people.Person# -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)
Try this... SELECT Category FROM Table WHERE ... #i# SELECT Person FROM Table WHERE Category = #i# #qry_people.Person# -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)
Might try this... #myQuery.categoryFieldName# #myQuery.personFieldName# Kristi - Original Message - From: Adaryl Wakefield To: [EMAIL PROTECTED] Sent: Friday, March 28, 2003 11:56 AM 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.
[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.