Thanks guys, some useful tips that led me to this ...
http://ttcfm.open.ac.uk/~bs3578/test1/abEmpAssets.cfm
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
Name Asset Category
#qEmpAssets.eName#
#aTitle#
#cCategory#
>from 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 510Notebook PC
>Nick Heap Motorola T60Mobile 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 XLLaser Printer
>Office Manager Epson Phaser Laser Printer
>Glyn Martin Toshiba Tecra 8000Notebook PC
>Glyn Martin Nokia 7650 Mobile Phone Bluetooth
>
>I am trying to use a variable LastEmp and but the
>output is just the same as the original.
>
>My script is ...
>
>
>
> Name Asset Category
>
>
>
>
>
>
>
>
> #eName#
> #aTitle#
> #cCategory#
>
>
>
>
>
>
>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
