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 ?
--
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 12747 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len
The Professional version does not have this message
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:320679
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
