RO
-----Original Message-----
From: Ryan Kime [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 3:35 PM
To: '[EMAIL PROTECTED]'
Cc: Robert Orlini
Subject: RE: Scheduled email
Hey Robert,
Why not try it this way...once the user login=2, add a record to a table which records the email address, name, and a timestamp. Then write a scheduled event in cf admin which runs a page (daily) containing SQL that checks the "login=2 table" for #DateFormat(DateAdd("d", -3, now()), "mm/dd/yyyy")# and use cfmail (with query attribute) to loop through the results.
-Ryan
-----Original Message-----
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 11:10 AM
To: CF-Talk
Subject: Scheduled email
Hell,
I was asked by a VP if the registration form I created would be able to send a bounce back email three days after a user logged in twice. The form tracks how many times someone uses their email address to access a trail database we have.
What is some of the code I need to be able to check when the login = 2 and then schedule an email three days afterwards to check on how they like the database they are using? Do I need to get into the CF Scheduler via the admin?
Thanks.
Robert O.
HWW
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
