I don't really understand what you are trying to do but in regards to the error message, I would try creating a loop to output the GETALLCALLS query.
-Aaron 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:231496 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
