OK I'm answering my own question - I needed to use the group attribute as well - its lucky I've got a column containing a single type I can group on, but this all seems unnecessarily cack handed to me.
Anybody got any thoughts? Tristram Charnley --------------------------- [EMAIL PROTECTED] Allaire Certified ColdFusion Developer ----- Original Message ----- From: "Tristram Charnley" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, March 22, 2002 3:58 PM Subject: cfmail query acting strange > 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
