>...<snip>...when you're using a query with
>your CFMAIL tag itself...<snip>...
>if any record within that recordset has an invalid address,
>the whole thing will fail at that point.
Exactly my situation. An external database with cfmail running with
query=.
Two choices:
1)do a pre-mail validation loop over the entire db; testing and flagging
failures.
2. Do a cfloop over the query and cfmail inside of it, with validation
at each step.
Went with 2 as one loop seems better than two. If the validation check
(a cfinclude) fails the email and all of its causes for failure are
logged to a db record, and at the end of the operation that single
failure report is emailed to the sender. Also put in try/catch behavior
that includes logging any additional problems with that same report, and
allows the process to continue on.
Not sure if the latter is such a bright idea in light of the validation
check, but I'll test a sample 10k mailer and see what happens with 10k
failures.
--------------------------------------------
Matt Robertson [EMAIL PROTECTED]
MSB Designs, Inc. http://mysecretbase.com
--------------------------------------------
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
