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,
c.assetcategory AS cCategory
FROM employees e
INNER JOIN assets a ON e.employeeID = a.employeeID
INNER JOIN assetcategories c ON a.assetcategoryID = c.assetcategoryID
ORDER BY e.lastname
</CFquery>
<table >
<tr>
<th width="20%"> Name </th> <th width="30%"> Asset </th> <th
width="30%"> Category </th>
</tr>
<tr >
<CFset LastEmp = "*" >
<CFoutput query="qEmpAssets" >
<CFif VARIABLES.LastEmp IS NOT trim(qEmpAssets.eName) >
<CFset VARIABLES.LastEmp = trim(qEmpAssets.eName) >
<CFelse>
<CFset #qEmpAssets.eName# = " " >
</CFif>
<td > #qEmpAssets.eName# </td>
<td > #aTitle# </td>
<td > #cCategory# </td>
</tr>
</CFoutput>
</table>
>from 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:320686
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
