select email, active, confirm_text
from EMailList
where UCase(email) = '#UCase(form.email)#'
update EMailList
set date_pending = '#DateFormat(Now(), application.GSHORTDTFRM)#',
bounce_count = 0
where UCase(email) = '#UCase(form.email)#'
insert into EMailList
(email, admin, active,
date_pending, confirm_text)
values
('#UCase(form.email)#', false, false,
'#DateFormat(Now(), application.GSHORTDTFRM)#', '#confirm_text#')
We have received your request to join the DBCS email notification list.
This request will expire in 21 days.
TO BECOME A MEMBER OF THE GROUP:
Go to the DBCS email confirmation site by clicking on this link:
http://www.dbcs4christ.com/email/confirm.cfm?e=#URLEncodedFormat(form.email)#&c=#confirm_text#
Your confirmation number is #confirm_text#.
(If clicking doesn't work, "Cut" and "Paste" the line above into your Web browser's address bar.)
If you did not request, or do not want, a membership in the DBCS email group, please accept our apologies and ignore this message.
Thank you for participating!
#application.webadmin_name#
DBCS Web Administrator
#application.webadmin_email#
delete from EMailList
where UCase(email) = '#UCase(form.email)#'
Your request to unsubscribe from the DBCS email notification list has been completed.
If you have any questions, please respond to this email.
Thank you for participating!
#application.webadmin_name#
DBCS Web Administrator
#application.webadmin_email#
DBCS EMail Notification List
The DBCS EMail Notification List is used to notify you of changes to the web site, as well as other school related announcements that are of importance to you.