You can just schedule a SQL job in your DB itself. But you can also do it
in CF and have it run from a scheduler

On Wed, 21 Nov 2001 [EMAIL PROTECTED] wrote:

> Hi
> 
> I have a field in my database table called 'itemexpires' which contains a 
> date field i.e. 17 November 2001.
> 
> What I would like to do is when the date is reached in the date field 
> 
> ie
> 
> if a record had a value in the 'itemexpires' field of 21 November 2001 this 
> entire record would be automatically deleted from the database a day later 
> (22nd November)
> 
> 1.) Can this be done with Coldfusion?
> 2.) How can it be achieved?
> 
> TIA
> 
> 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to