your current code, if you have posted it correctly, creates malformed
html: since you have the opening <tr> tag outside of your query output
but the closing </tr> inside of it, all your table rows after the first
one are missing the opening <tr> tag (check the generated source of the
page you posted a link to if you do not believe me).
for a change, try this for a CFOUTPUT with GROUP attribute solution:
<CFquery name="qEmpAssets" datasource="bs3578" >
...
</CFquery>
<table>
<tr>
<th width="20%"> Name </th> <th width="30%"> Asset </th> <th width="30%">
Category </th>
</tr>
<CFoutput query="qEmpAssets" group="eName">
<cfset lcount = 1>
<tr>
<td> #qEmpAssets.eName# </td>
<cfoutput>
<cfif lcount gt 1></tr><tr><td> </td></cfif>
<td> #aTitle# </td>
<td> #cCategory# </td>
<cfset lcount = lcount+1>
</cfoutput>
</tr>
</CFoutput>
</table>
plus: your total cell widths only amount to 80% of table width...
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Bob Sharp wrote:
> Thanks guys, some useful tips that led me to this ...
> http://ttcfm.open.ac.uk/~bs3578/test1/abEmpAssets.cfm
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:320687
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
