Automated Email Notification

Posted on 2006-06-06
Last Modified: 2013-12-24
Hi, ColdFusion Experts.  I need some help on my email notification.  I have an application that needs to submit an email notification to me if an order has been on hold for 5 days.  Can ColdFusion do this automatically?  Search the ORACLE database everyday and find all orders that have been on hold for more than 5 days without going to the application itself.  If yes, where should I trigger this command everyday?

Thanks -
Question by:jramos74
    LVL 9

    Accepted Solution

    CF can do this.   Using the administrator

    What I would do is create a page that has the query in it to find the results.  Then kick the email if the conditions are met, then you use the Administrator to run that page once a day.

    LVL 3

    Expert Comment

    you can also use the cfschedule tag if you dont have access to the cf admin

    Author Comment

    Thank you guys.  I have access to the adminitrator page for our site.  

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
    Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
    The purpose of this video is to demonstrate how to connect a WordPress website to Google Analytics. This will be demonstrated using a Windows 8 PC Go to your WordPress login page. This will look like the following: :…
    The purpose of this video is to demonstrate how to integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Setti…

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now