Yes. By using <cfloop query="(NAME)"> instead of <cfoutput query"(NAME)">
<cfmail>
<cfloop query="foo">
- loop content
</cfloop>
<cfloop query="bar">
- bar
</cfloop>
</cfmail>
I've also grown fond of outputting my desired email OUTSIDE of the
cfmail tag, using cfsavecontent to save it in a variable, then mailing
the variable - this is helpful when you're dealing with a lot of loops
and queries and you find it difficult to fit it all inside of the cfmail
restrictions.
so...
<cfsavecontent variable="foo">
<cfoutput query="qFoo">
-your output
</cfoutput>
<cfoutput query="qBar">
- your output 2
</cfoutput>
</cfsavecontent>
<cfmail>#foo#</cfmail>
HTH,
-Jeff
Richard Colman wrote:
>Is it possible to include results from two completely different queries
>within a CFMAIL command? How?
>
>Richard Colman
>Institute for Genomics and Bioinformatics
>949-824-1816, 701-5330
>[EMAIL PROTECTED]
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205924
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