You could use a cfloop inside the cfmail, and do the grouping in code, rather than through the tag. Or perhaps you could take the cfoutput where you are outputting the email text and move that before the cfmail, and append the output to a variable...then just output that one variable in the cfmail.
On 2/6/06, Brian Polackoff <[EMAIL PROTECTED]> wrote: > 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:231493 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
