Tha didn't change anything. Am I having a problem because it is in a loop?
-----Original Message-----
From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 07, 2000 1:24 PM
To: [EMAIL PROTECTED]
Subject: RE: Formatting Data
First things first. Don't select *
Select program, nomenclature
>From Equipment
Where Nomenclature='#SearchResults.key#'
ORDER BY Program
Secondly change your output to
<cfoutput query="qryDisplayResults" group="program">
<br>#Program#<br>
<cfoutput>
#Nomenclature#<br><br>
</cfoutput>
</cfoutput>
This should fix it.
--K
-----Original Message-----
From: Miriam Hirschman [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 07, 2000 10:15 AM
To: [EMAIL PROTECTED]
Subject: RE: Formatting Data
HI,
It didn't reaaly change the display
Here is my code:
<cfloop query="SearchResults">
<cfquery name="qryDisplayResults"
datasource="#application.settings.dsn#" dbtype="ODBC">
Select
*
From
Equipment
Where
Nomenclature='#SearchResults.key#'
ORDER BY
Program
</cfquery>
<cfoutput query="qryDisplayResults" group="program">
<br>#qryDisplayResults.Program#<br>
<cfoutput>#Nomenclature#<br><br></cfoutput>
</cfoutput>
</cfloop>
-----Original Message-----
From: Mark Armendariz [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 07, 2000 12:55 PM
To: [EMAIL PROTECTED]
Subject: RE: Formatting Data
I'm not sure if this is what you're looking for, but try useing grouped
outputs:
<CFQuery name="test" datasource="#application.test#">
SELECT FieldOne
FieldTwo
FROM Test
</CFQuery>
<CFOutput query="test" group="FieldOne">
#FieldOne# - #FieldTwo#
<CFoutput>
- #FieldTwo#
</CFOutput>
</CFOutput>
I apologize for the sloppyness of the example, but i hope you get the idea..
Mark
-----Original Message-----
From: Miriam Hirschman [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 07, 2000 12:48 PM
To: CF Forum
Subject: Formatting Data
I have a collection to pull up records based on a text string that a user
types in. My queries based on my collection return the correct data.
However, the data is like this
a b
a c
a d
b q
c s
c w
d r
e t
e b
I want it to be like this
a b
c
d
b q
c s
w
d r
e t
b
I tried loop and anything I can think of so that I can dispaly may data like
that,but I am at a loss.
Any help would be appreciated.
Thanks,
---miriam
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
