I always thought cfmail with the query attribute acted like <cfoutput
query...> What am I doing wrong all of a sudden? CFMAIL is sending multiple
separate emails, one for each record in the query, rather than multiple
records in the one email.
Whats happened?
<cfquery name="GetPubs" datasource="#variables.database#">
SELECT item_Id,Headline
FROM Publications
WHERE Item_ID IN (#form.item_id#)
Order By Item_ID
</cfquery>
<cfmail to="x"
from="y"
subject="Publication request"
query="GetPubs"
type="HTML">
<table width="400">
<tr><td>Item</td><td>Publication</td></tr>
<tr><td>#Item_id#</td><td>#Headline#"td></tr>
etc etc
</table>
</cfmail>
Tristram Charnley
---------------------------
[EMAIL PROTECTED]
Allaire Certified ColdFusion Developer
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
