Can anyone tell a lost programmer how to group with CFMAIL so that a
recordset with 100 records, grouped into 10 groups gets included into a
singe email, not 10 emails
Here's My Code:
<cfmail to="[EMAIL PROTECTED]" subject="Subject" type="html"
from="[EMAIL PROTECTED]">
<div align="center"><span class="style9"><br>
MICU CX At Scene After 10 Minutes Report
</span>
</div>
<hr size="3" color="990000">
<table width="100%" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
<td><span class="style5">Runnumber</span></td>
<td><span class="style5">Vehicle</span></td>
<td><span class="style5">At Scene Time</span></td>
<td><span class="style5">Cxl Time</span></td>
</tr>
<cfoutput query="GETALLCALLS" group="timedifference">
<tr bgcolor="##FFFFCC">
<td colspan="5"><span
class="style8">#timeDifference# minutes</span></td>
</tr>
<cfoutput>
<tr>
<td> </td>
<td><span class="style6">#Runnumber#</span></td>
<td><span class="style6">#Veh#</span></td>
<td><span
class="style6">#dateformat(atsdate,'mm/dd/yyyy')# #TimeFormat(AtsTime,'hh:mm
tt')#</span></td>
<td><span
class="style6">#dateformat(Cxldate,'mm/dd/yyyy')# #TimeFormat(cxlTime,'hh:mm
tt')#</span></td>
</tr>
</cfoutput>
</cfoutput>
</table>
</cfmail>
Every time an attempt is made I get the following error:
A query driven CFOUTPUT tag is nested inside a CFOUTPUT tag that also has a
QUERY= attribute. This is not allowed. Nesting these tags implies that you
want to use grouped processing. However, only the top-level tag can specify
the query that drives the processing
Any help is appreciated.
Thanks,
Brian
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231488
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
