Click to See Complete Forum and Search --> : FrontPage form to Access


CharlieA
09-02-2003, 05:46 PM
I have a form interfacing to an Access database on a Microsoft server using ASP. In addition to posting the entry I want to send the contents of the post to an email address. How can this be accomplished?

txmail
09-06-2003, 11:46 PM
Well once the update has been done to the database you can use CDONTS to send the info to a mail recipient.

tuanyong
09-07-2003, 10:26 AM
im doing a similar project regarding sending of emails to a recipient ... by the way what is CDONTS ??
can illustrate with examples ?
Thanks

rdoekes
09-07-2003, 12:05 PM
1. http://www.powerasp.com/content/hintstips/asp-email.asp
2. http://www.aspin.com/home/tutorial/email/cdonts
3. http://www.devasp.com/Samples/mail.asp
Just to name a few...


-Rogier Doekes

tuanyong
09-08-2003, 08:47 PM
Hi,

i have noticed that the few websites are indicating CDONTS only run on IIS, so im just wondering CDONTS can run on PWS because im currently using WIN98 in the office.

rdoekes
09-09-2003, 03:07 AM
I do not believe CDONTS runs under PWS.

CharlieA
09-09-2003, 04:28 PM
You have provided some great information. but I have two questions. I have a form on an ASP page feeding an Access database. I need the same data fed to the database to be emailed to a single address. 1) Within the ASP form, where do I put the CDONTS coding?
2) can the form data variables be inserted into the message to appear something like a confirmation page?

rdoekes
09-10-2003, 02:38 AM
1. When you submit the form, in the code where you insert the data in the database. You use the same Request.Form collection for database update and mail sending
2. yes

CharlieA
09-10-2003, 08:41 AM
The Microsoft server we are using in conjunction with FrontPage generates a "webbot" . Should the CDONTS coding be added to the webbot or can it be added out side. Forgive my lack of knowledge.

rdoekes
09-10-2003, 08:45 AM
i am not familiar with webbots. If you use classic ASP, all these things are possible

CharlieA
09-10-2003, 08:49 AM
Webbots are just one more nightmare Microsoft has created for us. Have a great day. Charlie

txmail
09-10-2003, 10:08 AM
Unless the webbot code is used for the database updates i would take it out all together.