Dreamcatchers
Posts: 120
|
| Posted: 11/29/2007, 9:05 PM |
|
I have a order confirmation form that shows what the customer ordered and then asked to click a confirm button. I added custom coded to the server on click event to write the form data to an email and send it to me.
In the email I also record customer contact information from a ccdlookup.
When the email arrives none of the form data is displayed, only the fields from the ccdlookup.
The record name is orderconfirm. I reference the fields with CCS displayed the properties such as orderconfirm.product_name.value
Any ideas what I am doing wrong?
A sample of the code is listed below:
' -------------------------
Dim first_name,last_name,Company,address1,address2,city,state,zip,users_email,phone, Country
Dim product_name,order_id, country_id, State_id
first_name = CCDLookUp("first_name", "users", "user_id=" & dbconnection1.ToSQL(CCGetUserID(), ccsInteger), dbconnection1)
users_email = CCDLookUp("email", "users", "user_id=" & dbconnection1.ToSQL(CCGetUserID(), ccsInteger), dbconnection1)
last_name = CCDLookUp("last_name", "users", "user_id=" & dbconnection1.ToSQL(CCGetUserID(), ccsInteger), dbconnection1)
Dim Mailer
Dim str_message
Set Mailer = Server.CreateObject("Persits.MailSender")
str_message="Dear " & first_name & ",<BR><BR>"
str_message = str_message + "Your request has been accepted and is being processed.<BR>"
str_message = str_message + "I will be in touch with you shortly with instructions and additional information.<br>"
str_message = str_message + "Please feel free to contact me for support.<BR><BR>"
str_message = str_message + "<b>Order Information:</b><br>"
str_message = str_message + " Order Number: " & orderconfirm.Order_ID.Value & "<br>"
str_message = str_message + " Product : " & orderconfirm.product_name.Value & "<br>"
str_message = str_message + " Quantity : " & orderconfirm.Quantity.Value & "<br>"
str_message = str_message + " Request Date: " & orderconfirm.Date_requested.Value & "<br>"
str_message = str_message + " Instructions: " & orderconfirm.notes.Value & "<br><br>"
str_message = str_message + "Sincerely,<BR><BR>"
Mailer.From = "admin@mysite.com"
Mailer.FromName = "admin"
Mailer.AddAddress users_email
Mailer.Host = "mail.mysite.com"
Mailer.IsHTML = True
Mailer.Subject = "ITSM Edu Product Request - " & orderconfirm.product_name.Value & " For: " & first_name & " " & last_name
Mailer.Body = str_message
mailer.username = "postmaster@mysite.com"
mailer.password = "123456"
Mailer.Send
set Mailer = Nothing
' -------------------------
_________________
Training and LMS Developer |
 |
 |
Dreamcatchers
Posts: 120
|
| Posted: 11/29/2007, 11:36 PM |
|
I have found a way to solve the problem. I changed the fields on the form from labels to text fields.
Since the form does no insert or update functions this is safe. I originally made easch field a label to ensure a read-only confirmation form.
What I don't understande is why I had to make the fields text boxes in order for the data to appear in my email.
_________________
Training and LMS Developer |
|
|
|
|
