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 no idea how to give the combo box a ‘var’ value like we do for a regular textfield. I have other pages where I have regular text fields that work fine as I can specify the ‘var’ value in the properties but not for combo boxes. I’m new to actionscript so please bear with me. Can anyone help me please…
Thank you all in advance.
Action Script for my button:
on (press) {
loadVariablesNum
("http://localhost/Test/acadForm.asp",0, "post");
nextframe();
}
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)
%>