why couldn't you just read SELECT all the emails that have not been sent
for that user , elegantly concatenate the bodies, and just let it rip?
"W Luke" <[EMAIL PROTECTED]> on 09/11/2001 11:58:59 AM
Please respond to [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
cc:
Subject: Complicated mail/DB problem
Hi.
Before I ask my question, I'd like to offer my sincerest condolences to
America, to the lost and anyone else affected by today's unbelievable
events. I was fortunate, or unfortunate enough to watch it live on TV -
how
lucky I/we are that we can be so detached from such devastation. God's
speed to all.
I have a complicated mail and DB question. On one of my sites, there are a
fair amount of "Email Notification" things going on with CFMail. For
instance, a user might asked to be notified of 3 or 4 things and will
receive 4 seperate emails as and when an even occurs. What I want to do is
instead of triggering cfmail each time, and sending hundreds of emails,
insert the data into the Database and run CFSchedule periodically to send
the emails.
So let's say cfschedule runs a script every 30 minutes. The script finds
50
records, 30 of which are distinct email addresses - cfmail sends them all
out, and a "MailSent" Yes/No field is set to Yes. The other 20
records/emails are destined for 5 people - 4 emails each. What I need to
do
is loop through them, checking the "mailtype" field, collating *one* email
for each 5 people.
Let's say [EMAIL PROTECTED] has 4 emails in the Database that are about to be
sent. One contains information on the number of hits his banner has had
today; the 2nd informs him of updated info in the news section. The 3rd
details an Advert he has that is expiring in a days time, and the 4th shows
site-stats. Each of these emails or records in the DB will have a unique
"MailType" field. What I'd then need to do is "create" one email to send
to
[EMAIL PROTECTED] but which contains all 4 records.
Can anyone advise how I'd go about this? Currently my Table in the DB
(called MailSpool) is as follows:
mailID
mailTo
mailFrom
mailSubject
mailBody
mailSent (YesNo)
mailDate (Time/date field)
mailType
Any advice or tips would be appreciated.
Will
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
