Send email and send to database at the same time 1

[LonnieJohnson]

I have a very simple form that I have put together by getting bits and pieces here and there. I would like to save the results of the choice in an Access database on the server and send an email at the same time. My code to send stuff from the form to the database does not fire. I have put in functions that send a static record to the database and it is fine. Does it have something to do with my action in the form?

Here is the link

http://www.canaanwc.org/content/survey.asp

Thanks.

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[vacunita]

Your action is telling the form to send it via an email and that's it, it won't do anything else with the information.

For starters its never recommended to use the mailto: action in a form because you rely on your user to have an email client not only installed, but also configured to send the email, and actually have the user send the email. They can just as easily disregard it, or have no email client configured and no email will be sent.

If you want it to do both things, change your form's action so it points to a script that will do the db updating and then send the email, via the server instead of the client.

For specifics on how to do both, you might want to ask in the forum for the server side language you are using. In your case I assume its ASP so:
forum333 or forum855

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[LonnieJohnson]

Thanks.

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!