Quite simple to solve, i simply put the above query into a cfinclude and popped it into the mail body and it worked a treat
jamo > hi all, > > I use the following to output products by vendor > > <cfquery name="getproducts"> > select * from products > group by vendorname > </cfquery> > > <cfoutput query="getproducts" group="vendorname"> > #vendorname# > <cfoutput> > #productsname# > </cfoutput> > </cfoutput> > > > This will output a vendor, then all their products, then vendorname and > all their products and so on. > > How can i do this within a cfmail tag. I have tried numerous methods but > to no avail. The only way i can think of is to create a string using the > method above, and then inserting the string in the mial. I have tried to > use the query and group attributes on cfmail but that just sends multiple > emails, one from each vendor to the recipient but i need all vendors in > one mail. Any thoughts > > Jamie --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
