Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4

Thread: Triggering -

  1. #1
    Regular Coder
    Join Date
    Jun 2006
    Location
    UK
    Posts
    907
    Thanks
    301
    Thanked 2 Times in 2 Posts

    Question Triggering -

    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
    Senior Coder Spudhead's Avatar
    Join Date
    Jun 2002
    Location
    London, UK
    Posts
    1,856
    Thanks
    8
    Thanked 110 Times in 109 Posts
    Actually, the easiest way i found to automate stuff was... to cheat

    Write a server-side script that'll do your job, write a batch file that'll open that page (write "start http://www.yoursite.com/file.asp" to notepad and save it as doMyStuffForMe.bat), and then set a Scheduled Task that runs that file.

    Simple

  • #3
    Senior Coder
    Join Date
    Nov 2002
    Location
    North-East, UK
    Posts
    1,265
    Thanks
    0
    Thanked 0 Times in 0 Posts
    If you are going down that path then you may want to checkout the taskkill command

  • #4
    Senior Coder Spudhead's Avatar
    Join Date
    Jun 2002
    Location
    London, UK
    Posts
    1,856
    Thanks
    8
    Thanked 110 Times in 109 Posts
    What? Memory is finite??



  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •