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 )
----- Original Message ----- From: "Adrian Lynch" <cont...@adrianlynch.co.uk> To: "cf-talk" <cf-talk@houseoffusion.com> Sent: Wednesday, March 18, 2009 11:26 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 layout mind. > > 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 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:320684 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
