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 2 of 2
  1. #1
    New Coder
    Join Date
    Jan 2005
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    form to jmail AND access database

    Hi, I am using jmail to send forms via email -works fine. But i also want to send the form data to a database, this is where I am having problems.

    I am using dw8, it will write to the database but I cannot get it to then send the form via email and vice versa. The data has to be in a form with a submit button, and it only wants to do one thing, either write to the database or go to the jmail page.

    The layout of the forms:
    form - someone fills out
    jmail page 1 - this processes the form and sends the email and then forwards page to
    jmail page 2 - the second page, for a completely differently formatted email, but with the same content - back to home page

    So I have data to play with but I am not experienced enough with asp to know how to send the data to the database - I can get out pretty much everyting I need (the database connection works), but writing back does not work the way I am doing it.

    Do i have to have the data in a form to write to the database (Iguess not But I dont know how to do it - i have all variables as session variables)
    Any ideas?

  • #2
    Senior Coder Spudhead's Avatar
    Join Date
    Jun 2002
    Location
    London, UK
    Posts
    1,856
    Thanks
    8
    Thanked 110 Times in 109 Posts
    I shouldn't think that you need two processing pages, there's no reason why one page can't send a number of emails and write it to the database. But in any case we need to see what code you've got already so we can figure out why it's not working right.


  •  

    Posting Permissions

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