1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

How do i get a database to tell me when it has a new record?

Discussion in 'Software Development' started by Spu, Jan 23, 2002.

Thread Status:
Not open for further replies.
  1. Spu

    Spu Thread Starter

    Joined:
    Nov 25, 2001
    Messages:
    71
    The question is,

    How do I get a database (Access) to tell me when it has a new record?

    I want to be emailed when a user has completed a form which is then sent to a database to be stored. Do i attach a cgi code to the submit button so when the user clicks two operations happen at the same time (cgi email and insert database record), or use some form of code that will make the database tell me when its got a new record? With either option, please tell me !!!

    I'm using ASP/VBscript.

    Thanks for the help ! ! !

    Spu
     
  2. Bob Henderson

    Bob Henderson

    Joined:
    May 26, 1999
    Messages:
    16
    Personally I would include some script in the asp page that your form calls on which would trigger the email at the same time as it does the data insert. I cant quote the code off the top of my head but I seem to recall it's fairly simple.
    Cheers, Bob
     
  3. Rockn

    Rockn

    Joined:
    Jul 29, 2001
    Messages:
    21,334
    You can use CDONTs or a mail component like ASPMail to do this. You can set it up as part of the script in the form that will take info from the form and fill it into the appropriate mail fields and send. Should probably be set at the end of your codes form validation in case something isn't filled in correctly it won't shoot off an email until the script executes correctly.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/66079

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice