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 layout mind.
Adrian
> -----Original Message-----
> From: BobSharp [mailto:[email protected]]
> 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 cCategory
> Doug Briggs HP Omni 510 Notebook PC
> Nick Heap IBM Netfinity Server Desktop PC
> Nick Heap HP Omni 510 Notebook PC
> Nick Heap Motorola T60 Mobile Phone
> Audrey Ibbotson Toshiba Satelite XL Notebook PC
> Karen Kear Viglen 733 Desktop PC
> Karen Kear HP Omni 510 Notebook PC
> Office Manager HP LaserJet XL Laser Printer
> Office Manager Epson Phaser Laser Printer
> Glyn Martin Toshiba Tecra 8000 Notebook PC
> Glyn Martin Nokia 7650 Mobile Phone
> Bluetooth
>
> I am trying to use a variable LastEmp and <CFif> <CFset> but the
> output is just the same as the original.
>
> My script is ...
>
> <table >
> <tr>
> <th> Name </th> <th> Asset </th> <th> Category </th>
> </tr>
> <tr >
> <CFoutput query="qEmpAssets" >
> <CFif VARIABLES.LastEmp IS eName >
> <CFset eName = ' ' >
> <CFelse>
> <CFset VARIABLES.LastEmp = eName >
> </CFif>
> <td > #eName# </td>
> <td > #aTitle# </td>
> <td > #cCategory# </td>
> </CFoutput>
> </tr>
> </table>
>
>
>
> Am in anyway close to achieving it ?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320680
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
