Flash MX Combo Box Component

programming flash
1

Hi I’m trying to insert some data into my DB from two Combo Boxes in Flash. I’m not quite sure how to go about it. I have one combo box listed in the actionscript below. Can anyone help me please…
Thank you all in advance.

Here is my actionscript:


on (release) {
function getthevalue() { 
passthis = major.getSelectedItem(); 
if(passthis != "")
{
loadVariablesNum ("[http://localhost/test/acadForm.asp](http://localhost/test/acadForm.asp)", "0", "POST"); 
}
else{
_root.messageBox.text = "please select an option";
}
} 
nextFrame();
}

Here is the ASP Code:

 
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
strMajor = Request.Form("major")
strCollege = Request.Form("college")
'Response.Write(strMajor) & "<br>"
'Response.Write(strCollege) & "<br>"
MyPath=Server.MapPath("uginfo.mdb")
Set Conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & MyPath
SQL = "INSERT INTO acad_choices (major, college) VALUES('"&strMajor&"', '"&strCollege&"')"
'Response.Write(SQL)
conn.Execute(SQL)
%>