I would be doing a loop, and I would also ask what version of CF if its CFMX6+ then cfmail its ok to use. But god forbid, I wouldn't use more than one email address for something like this in any one field To:, CC: or even BCC:
The reason being and its very simple, you could be seen as a mass mailout and get blocked by many ISP's. However thats not to day that you might not with a cfloop either, but at least the emails when spooled will not go unless the server is idle reducing the time between emails being sent out. On 5/11/07, Joel Watson <[EMAIL PROTECTED]> wrote: > > I have a forum in which users can subscribe to particular threads. When > other users make replies, all users who are subscribed to the thread will > receive an email (basic stuff, I know). > > My question is regarding what the best practice for handling this mailing > should be. > > Currently, I am querying my db to get the emails of subscribed > users. Using the listAppend function, I create a list of emails and pass it > into the bcc field (I don't want every user to get the emails of every other > subscribed user). > > Right now, this is not a problem as the user base is small. However, if > it increases (and I expect it to very soon), I am wondering if this is the > best way to do this. > > So my question is this: Would it be best to continue with what I am doing > (list of addresses), and is there a certain limit to the number of addresses > that can be in the bcc field? > > Or...should I loop over the cfmail tag itself, running the tag the same > number of times as there are subscribed users? In this option, are there > going to be significant performance issues if, say, there are 500 subscribed > users (thus the cfmail tag running 500 times?) > > And, of course, there may be other ways to do this entirely that are > better than either of these options. I am definitely open to those as well. > > Thanks! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by AdobeĀ® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277738 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4