True, Calvin... and sometimes you get really great advice! Sometimes you end up with a mishmash of options that just mean you know less than you started out with. Gotta love it.
But as a side note, I've done things like all 4 of the below, thinking I was doing really great stuff by altering the behaviors of things to be "creative" in my development. What you generally end up with is something that's cool and unique, and hard to support, and easily broken. If you've got 2 separate cfmail tags, you can tell at a glance what each does, you have no extra code to read thru to remember what you did or figure out what someone else did, you have 2 tags that execute as purposed, each of those tags executes quite efficiently, and there's nothing else going on. Of ALL the options we've discussed, other than 2 separate tags and individual emails to each student, the only other option I'd really go for is: <cfmail to="[EMAIL PROTECTED]" bcc="#valueList(student_query)#"> And that I'd want to test, VERY thouroughly, to insure that on the off chance I end up with a student_query that's over 1,000 records I wasn't going to bomb the app. And I'd include a failto= attribute (if you're using 6.1 anyway) in case the messages fail. If you use 2 separate tags, each student gets their own copy, which is essentially how cfmail was "intended" to work in the first place. If you use the BCC attribute, you're handing the responsibility for the success of a much larger single operation off to an external system (the mail server), whereas if you use single emails from 2 cfmail tags you can be relatively certain that (being a simpler, smaller act of sending on mail to one recip for each row in the query) it will succeed. If I were going for "creative" I'd say hell yeah, do it however and tell us what nifty thing it was. I used to do that. At this point, I get more satisfaction from developing something that's standards-based, rock-solid, and as self-contained and cohesive as possible. Ain't tellin ya what to do, just why I'd do what I'd do. Laterz, J -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com On Fri, 14 Jan 2005 10:40:49 -0500, Calvin Ward <[EMAIL PROTECTED]> wrote: > That's what makes a discussios so great, look at all the options you get! > > Udf in BCC > IIF in BCC > Separate cfmail > Add email to record set > > - Calvin > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190462 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