it won't if you code it properly.
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
BobSharp wrote:
Thanks for the tip about Grouping
Sadly, it would remove the eName column, when I just want it blank.
( ie. output shifts left one column )
Thanks guys, some useful tips that led me to this ...
http://ttcfm.open.ac.uk/~bs3578/test1/abEmpAssets.cfm
CFquery name=qEmpAssets datasource=bs3578
SELECT concat(e.firstname, ' ', e.lastname) AS eName,
LEFT(a.assetdescription,30) AS aTitle,
PM
Subject: RE: Eliminating repeated data in CFoutput field
Order your query by eName then do something like this:
cfoutput query=yourQuery group=eName
#yourQuery.eName#
cfoutput
#yourQuery.aTitle#
#yourQuery.cCategory#
/cfoutput
/cfoutput
You'll need to tweak it to fit in your table
your current code, if you have posted it correctly, creates malformed
html: since you have the opening tr tag outside of your query output
but the closing /tr inside of it, all your table rows after the first
one are missing the opening tr tag (check the generated source of the
page you posted a
Thanks for the tip about Grouping
Sadly, it would remove the eName column, when I just want it blank.
( ie. output shifts left one column )
No, it needn't do that, and grouping is really the correct way to
solve this problem. You can find an example here:
/CFoutput
/tr
/CFoutput
/table
- Original Message -
From: Dave Watts dwa...@figleaf.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Thursday, March 19, 2009 2:23 PM
Subject: Re: Eliminating repeated data in CFoutput field
Thanks for the tip about Grouping
Message -
From: Dave Watts dwa...@figleaf.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Thursday, March 19, 2009 2:23 PM
Subject: Re: Eliminating repeated data in CFoutput field
Thanks for the tip about Grouping
Sadly, it would remove the eName column, when I just want it blank
Yep ! That's it.
http://ttcfm.open.ac.uk/~bs3578/test1/abEmpAssets_02.cfm
Thanks
- Original Message -
From: Nick G ngiova...@gmail.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Thursday, March 19, 2009 9:14 PM
Subject: Re: Eliminating repeated data in CFoutput field
You
Bob, did you try the code I posted earlier?
Using rowspan is the ideal way to do this, and it looks like what I wrote
should work fine...
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
rom this output, I would like to eliminate repeated names
eName aTitle cCategory
Doug Briggs HP Omni 510Notebook PC
Nick Heap IBM Netfinity Server Desktop PC
Nick Heap HP Omni 510
.
Adrian
-Original Message-
From: BobSharp [mailto:bobsh...@ntlworld.com]
Sent: 18 March 2009 22:45
To: cf-talk
Subject: Eliminating repeated data in CFoutput field
rom this output, I would like to eliminate repeated names
eName aTitle
Hi Bob,
That's not working because cfset eName = / is just setting a empty
variable named eName it's not updating the query variable eName. Since your
in a cfoutput with a query attribute CF's going to look for a query variable
that matches first. IIRC the order of lookup is query, arguments,
This is not perfect (should really be using functions, for starters), but I
think it will do what you want...
cfquery name=qEmployees dbtype=Query
SELECT DISTINCT eName
FROM qEmpAssets
/cfquery
table
thead
tr
th Name /th
th
13 matches
Mail list logo