Skip to main content
Participant
May 15, 2006
Question

Deleting Rows Automatically By Date

  • May 15, 2006
  • 3 replies
  • 389 views
Hi all,

I am putting together a website in which certain database entries will need to be deleted after a certain amount of time (eg. 30 days after it was entered). Is it possible to have this happen automatically? Could I set up a delete script on the server to be run once a day? Thanks for any available help.

-=Chris
    This topic has been closed for replies.

    3 replies

    Inspiring
    May 16, 2006
    > Could I set up a delete script on the server to be run once a day?

    This is more a job for the database server, coldfusion can do it via
    schedule, but coldfusion is your biness logic tier, not your data tier. If
    this is a choice you have, of course.

    "C T 2" <webforumsuser@macromedia.com> wrote in message
    news:e4aspb$dh2$1@forums.macromedia.com...
    > Hi all,
    >
    > I am putting together a website in which certain database entries will
    need to
    > be deleted after a certain amount of time (eg. 30 days after it was
    entered).
    > Is it possible to have this happen automatically? Could I set up a delete
    > script on the server to be run once a day? Thanks for any available help.
    >
    > -=Chris
    >


    Inspiring
    May 15, 2006
    Depending on the db you are using, and the os of your db server, you might be able to do this without cold fusion.
    Participating Frequently
    May 15, 2006
    A good place to start would be by researching Scheduled Tasks and cfschedule

    Phil