Yep ! That's it. http://ttcfm.open.ac.uk/~bs3578/test1/abEmpAssets_02.cfm
Thanks ----- Original Message ----- From: "Nick G" <ngiova...@gmail.com> To: "cf-talk" <cf-talk@houseoffusion.com> Sent: Thursday, March 19, 2009 9:14 PM Subject: Re: Eliminating repeated data in CFoutput field > > 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:320723 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
