Member Avatar for cancer10

Triggering -

Hello,

Need help :)

Herez the scenario:

I am maintaining a list of members of my site in a database. All members have an expiry date column in a table which is in mm/dd/yyyy format. I want that every members should be emailed on the day of their expiry automatically. I dnt wanna search for members and then mail then manually or if I m out on vacation it should do the work for me.

I have heard this can be done using triggers, but not sure how to use it.

Can u help me? also is there any other way apart from using triggers?


PS: Corn Jobs are not enabled in my webhost just in case if you are going to suggest me that. :)

Thanx in advance.

  • 2 Contributors
  • 1 Reply
  • 127 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by davidcairns
Member Avatar for davidcairns

If you want to use triggers that is a database question rather than an ASP question, and it very much depends on what database you're using. Having said that most database triggers are designed to operate on table row changes, not on changes to system parameters such as date.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.