hi everyone . i’m on a objective to successfully retreive or insert data into database by asp from flash. i got no basic knowledge on how should asp work inorder to retrieve data successfully, so pardon me if i state ridiculous statements. i’m new to this forum as well, and i hope my queries could be answer here.
i met upon this tutorial by kirupa.com , http://www.kirupa.com/developer/actionscript/forms_database.htm which gave me the detail guide on how to do a flash and database integration. but im having big troubles syncing both of them to achieve my results. i followed the steps, and i used apache tomcat which is not stated inside the tutorial. or is there a way to run the asp without tomcat? i’m not very sure too. please guide me here. my URL loaded in the button of the flash is an URL to the asp in my local directory. “on(press){
getURL(“http://localhost:8080/examples/jsp/processForm.asp",0,"post”);
}” . and it links to my asp.
my asp code processForm.asp would be :
“<%@language = “VBScript” %>
<%
strFirst = Request.Form(“fname”)
strLast = Request.Form(“lname”)
strEmail = Request.Form(“email”)
strMessage = Request.Form(“message”)
MyPath=Server.MapPath(“C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\examples\jsp\example.mdb”)
Set conn = Server.CreateObject(“ADODB.Connection”)
conn.Open “Driver={Microsoft Access Driver (*.mdb)};” & _
“DBQ=” & MyPath
SQL = “INSERT INTO contacts (FirstName, LastName, Email, Message) VALUES (’”&strFirst&”’,’"&strLast&"’,’"&strEmail&"’,’"&strMessage&"’)"
conn.Execute(SQL)
%>
"
and the flash, db, and asp is placed in “C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\examples\jsp”.
i run the asp but nothign shows and nothing occurs.
if there’s any big mistakes , please correct me. i’ll appreciate alot. thanks.