I’m clueless when it comes to ASP, but I having to create a contact form for a site I’m working on in Flash. I’ve done some tutorials but for some reason it simply isn’t working. (yes, I do have ASP technology on the server). Here is what I got:
here is what my form looks like. All of the input text fields are in a movie clip called myForm. The fields are labeled:
fname (first name)
lname (last name)
and so forth and so on…
here is what my properties look like for those fields:
This is what my ASP page code looks like:
<%@language = “VBScript” %>
<%
strFirst = Request.Form(“fname”)
strLast = Request.Form(“lname”)
strEmail = Request.Form(“email”)
strMessage = Request.Form(“message”)
MyPath=Server.MapPath(“webcontacts.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)
%>
Ok,now why isn’t this working??? I’m begging for help on this one. Here is a link to the site that the form is currently on (but of course, not working)
Spectrum Productions
