CFMail return of two queries?

[scotiegirl]

Help. I have an e-commerce site where the receipt I need to email out must
contain the returned information of two queries. I know a <cfmail> tag can't
have a <cfoutput query=****> tag residing in it. And all the information I've
been finding gives me information on sending the output of one query. Can
anyone give me some guidance? Thanks in advance.

[scotiegirl]

Oh... I'm sorry.... Scratch that. Three queries.

[Stressed_Simon]

You must treat cfmail like cfoutput so you must escape any # and so to display query data you must use cloop.

ie.
<cfloop query="QueryName">
#data#
</cfloop>

HTH

[Tom Jordahl]

You should use Query of Queries to do a join on the two/three result sets
(aka tables).

--
Tom Jordahl
Macromedia Server Development

[scotiegirl]

I'm sorry, I'm confused.....

They are being returned as tables... but I'm not sure I understand "Query of Queries"?

[scotiegirl]

This doesn't seem to work.... If the query MakeReceipt1 is already called I should be able to just say <cfloop query="MakeReceipt1">?

Correct?

[Tom Jordahl]

See the docs:
[url]http://livedocs.macromedia.com/coldfusion/7/htmldocs/00001263.htm[/url]

--
Tom Jordahl
Macromedia Server Development