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
