Why *not* use a CF scheduled task that runs every minute or so? You could also use a database trigger that runs when a date/time record is inserted into the respective table.
-----Original Message----- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Monday, April 06, 2009 2:07 PM To: cf-talk Subject: Never Ending Program? I need to write a routine that executes various actions based on user entered dates/times. The dates/times to act would be listed in a data base. I really don't see a way to use the Scheduled Tasks page for this as that seems more in tune to batch processing type stuff. The only way I can think of doing this is to write a never ending program that keeps checking to see if an action is ready to kick off. Is there a better way to handle this? Thanks Robert B. Harrison Director of Interactive Services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be &. Plug in to our blog: A&W Unplugged http://www.austin-williams.com/unplugged ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321370 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4