Actually, I wanted to loop over two different queries, since each one delivers multiple records that need to be inserted into the email message. You reply implies that this is not possible within CFMAIL. So, it sounds like I need to build the results of the second query into a text string, etc. and just insert it as a static variable into CFMAIL?
TNX for your comments. -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, May 06, 2005 3:41 PM To: CF-Talk Subject: RE: Two queries within CFMAIL > Is it possible to include results from two completely different > queries within a CFMAIL command? How? I'm not exactly sure what you're trying to do, but yes, you can reference variables from two different queries. However, you can only loop over one query with the QUERY attribute of CFMAIL. The CFMAIL tag is very similar to CFOUTPUT, except that instead of generating output for your HTTP response, it generates output to be sent to an SMTP server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205927 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