You should be able to do this but I haven't tried it.
<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>
<td > <CFoutput> #qEmpAssets.aTitle# <br /></CFoutput> </td>
<td > <cfoutput> #qEmpAssets.cCategory# <br /> </cfoutput></td>
</tr>
</CFoutput>
</table>
On Thu, Mar 19, 2009 at 1:45 PM, BobSharp <bobsh...@ntlworld.com> wrote:
>
> Tried it several ways, yet to get it to work as I want it.
> http://ttcfm.open.ac.uk/~bs3578/test1/abEmpAssets_02.cfm<http://ttcfm.open.ac.uk/%7Ebs3578/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" <dwa...@figleaf.com>
> To: "cf-talk" <cf-talk@houseoffusion.com>
> 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:320714
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
