Forums

ASP

This topic is locked

jmail and write to access database

Posted 08 Dec 2007 13:09:01
1
has voted
08 Dec 2007 13:09:01 sn b posted:
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?

Reply to this topic