Classic ASP Discussion - Cdonts and Database

Print Page | Close Window

Cdonts and Database

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=17274
Printed Date: 29 March 2026 at 2:58pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Cdonts and Database

Posted By: KenW
Subject: Cdonts and Database
Date Posted: 16 November 2005 at 3:19pm

Can anyone please help I have a form when after checking is entered into an access 2000 database (See Code Below) which works fine. However I would then like to send the information entered into the database by email Cdonts.

        <% 'insert into database & move to next page if there are no errors
        '***************************************************************
        If strErrorMsg = "" Then
       strSQL = "SELECT * FROM tblappointments"
       objRst.Open strSQL, objConn, adOpenDynamic, adLockOptimistic
       objRst.AddNew
       objRst("apptDay") = strapptDay
       objRst("apptMonth") = strapptMonth
       objRst("apptYear") = strapptYear
       objRst("apptTime") = strapptTime
       objRst("apptFNAdvisor") = strapptFNAdvisor
       objRst("apptAdEmail") = strapptAdEmail
       objRst("clientTitle") = strclientTitle
       objRst("clientFirstName") = strclientFirstName
       objRst("clientLastName") = strclientLastName
       objRst("clientSubject") = strclientSubject
       objRst("receptionistFirstName") =      strreceptionistFirstName
       objRst("bookingTime") = strbookingTime
       objRst("bookingDate") = strbookingDate
            objRst.Update
            objRst.Close
            objConn.Close
            Set objRst = Nothing
            Set objConn = Nothing
            strErrorMsg = "User data entered into database successfully...<br>Please Email the Advisor about the Appointment"

        End If
End If
%>

The email address it needs to be sent to is:

objRst("apptAdEmail") = strapptAdEmail

Many thanks in appreciation of your help

-------------
Ken Home User enjoys ASP as a hobby

Replies:

Posted By: Scott07
Date Posted: 25 November 2005 at 3:30pm

As long as your sure you have the cdonts component installed then there is a nice tutorial below so you can learn it for yourself

http://www.webwiz.net/asp/tutorials/email_using_cdonts_tutorial.asp

-------------
http://www.worldsofwar.co.uk - Worlds of War II