Tried it several ways, yet to get it to work as I want it.
http://ttcfm.open.ac.uk/~bs3578/test1/abEmpAssets_02.cfm
Must be the postion of the <CFoutput>, in relation to the <TD> table cells.
<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 eName
</CFquery>
<table border="1" >
<tr>
<th width="20%" > Name </th>
<th width="30%" > Asset </th>
<th width="30%" > Category </th>
</tr>
<CFoutput query="qEmpAssets" group="eName" >
<tr >
<td > #qEmpAssets.eName# </td>
<CFoutput >
<td > #qEmpAssets.aTitle# </td>
<td > #qEmpAssets.cCategory# </td>
</CFoutput>
</tr>
</CFoutput>
</table>
----- Original Message -----
From: "Dave Watts" <[email protected]>
To: "cf-talk" <[email protected]>
Sent: Thursday, March 19, 2009 2:23 PM
Subject: Re: Eliminating repeated data in CFoutput field
>
>> 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 )
>
> No, it needn't do that, and grouping is really the correct way to
> solve this problem. You can find an example here:
>
> http://www.adobe.com/education/instruction/teach/coldfusion/CF8-2_advanced_cf8_development_unit3.pdf
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
>
> Fig Leaf Software provides the highest caliber vendor-authorized
> instruction at our training centers in Washington DC, Atlanta,
> Chicago, Baltimore, Northern Virginia, or on-site at your location.
> Visit http://training.figleaf.com/ for more informatio
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:320711
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
