Automatically update or delete record(s) after x time in coldfusion

Question

I've searched all over the net for this. Hope that someone's got something.

How would a record in a database be updated automatically after x time n coldfusion?

I know how to manually do it by writing an sql that performs an action to all records older than x time based on the timestamp.

How would this be done automatically?

Kind Regards, Nich

Answer 1

Write out the query to a new ColdFusion template, then use CFSCHEDULE to schedule a task to run that template at the appropriate time.

CFSCHEDULE docs: http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_r-s_11.html

Answer 2

You can created a scheduled task in the ColdFusion Administrator (CFIDE) that runs a cfm script. Inside your cfm script simply write a query to update the data based on the age of the record.