I have a form based in part on [COLOR=black]Flash[/COLOR][COLOR=black] Forms and Database Integration tute by Digitalosophy [/COLOR]http://www.kirupa.com/developer/actionscript/forms_database.htm
Is it possible to also send the data via an email to several recipients, two of whom will be determined by a field in the form.
AS
on(press){
function onSubmit() {
}
// Initialize form variables:
userData = new LoadVars();
var myListbox = OnlineAdTypes;
userData.senderFirstName = senderFirstName;
userData.senderLastName = senderLastName;
userData.senderPhone = senderPhone;
userData.senderEmail = senderEmail;
userData.dateSubmitted = dateSubmitted;
userData.instructions = instructions;
// Get list box selection(s):
// getSelectedItems returns an array of objects with two properties: label
// and data
OnlineTypesObjectArray = OnlineTypes_myListbox.getSelectedItems();
for (var i = 0; i < OnlineTypesObjectArray.length; i++) {
currentOnlineType = OnlineTypesObjectArray*;
formData.OnlineTypes* = currentOnlineType.label;
}
// Submit the data and advance to frame 5
// Change the URL to point to the CFM or ASP file on your
// web server.
userData.send
("processForm2.asp",0,"post");
gotoAndStop(5);
}
ASP
strsenderFirstName = Request.Form("senderFirstName")
strsenderLastName = Request.Form("senderLastName")
strsenderPhone = Request.Form("senderPhone")
strsenderEmail = Request.Form("senderEmail")
strdateSubmitted = Request.Form("dateSubmitted")
strOnlineTypes = Request.Form("OnlineTypes")
strInstructions = Request.Form("Instructions")
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"DBQ=instructions.mdb;"
SQL = "INSERT INTO contacts (senderFirstName, senderLastName, senderPhone, senderEmail, dateSubmitted, onlineTypes, Instructions) VALUES ('" & strsenderFirstName & "','" & strsenderLastName & "','" & strsenderPhone & "','" & strsenderEmail & "','" & strdateSubmitted & "','" & stronlineTypes & "' ,'" & strInstructions & "')"
conn.Execute SQL, recaffected