How about creating a page that queries the database for all items that need to be deleted based on your filter, then run a delete statement. You would then load up the page on the server and create a schedule for it to run at a certain time each day.
---------- Original Message ---------------------------------- From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 21 Nov 2001 14:46:43 EST >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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
