Other Queries in CFMAIL HTML Format

[dimsis]

I have a database with emails of my site members and i'd like to send them an HTML newsletter every week.
The problem is that the body of the email must be created automatically by running some other queries and i'm getting a "nested query" error.

Let's say i've got a query that gathers all the members and emails and i'm using it with cfmail "batch" send the email to all these folks:
<CFQUERY Name=&quot;Member&quot; Datasource=&quot;mydsn&quot;>
SELECT MemberPassword
FROM Members
WHERE MemberEmail='#MemberEmail#' AND MemberPassword='#MemberPassword#'
</CFQUERY>

and another query that get's some other infos (news):
<CFQUERY Name=&quot;MyNews&quot; Datasource=&quot;mydsn&quot;>
SELECT newID, new, newdate
ROM codenews
WHERE code_new_date BETWEEN #now()# AND #DateAdd('D', -5, Now())#
ORDER BY code_new_date DESC
</CFQUERY>

When i need to send the newsletter i have:

<cfmail query=&quot;Members&quot; to=&quot;#MemberEmail#&quot; from=&quot;#mymail#&quot; subject=&quot;&quot; type=&quot;HTML&quot;>

BUT HERE I MUST HAVE THE RESULTS OF THE OTHER QUERY MYNEWS
IF I MAKE AN OUTPUT I&quot;VE GOT A NESTED ERROR
Example:
<cfoutput query=&quot;MyNews&quot;>
(#newdate#) #new#
</cfoutput>

</cfmail>

How can i avoid this?

Thanx in advance i know someone has a question for this one!
Dimitris

 

[iqof188]

Replace <CFLOOP QUERY=&quot;MyNews&quot;> with <CFOUTPUT QUERY=&quot;MyNews&quot;>. <CFMAIL> acts the same as <CFOUTPUT>, so it should not be a surprise you get the &quot;nested&quot; error.
Hope this helps...


<webguru>iqof188</webguru>