Hey Guys,
I’ve been trying to follow this tutorial and it’s killing me!!!
http://www.smartwebby.com/Flash_and_ASP/
Can someone tell me what I’m doing wrong here?!?
I uploaded the .fla file and here is the asp code:
<%@LANGUAGE=“VBScript” %>
<%
Option Explicit
Response.buffer=True
response.Expires=-1500
%>
<%
Dim DBConn, strDB, strInsertSQL, strName, strSname, strEmail, strTel, strAddrs, strCity, strCntry
strDB = “DRIVER={Microsoft Access Driver (*.mdb)};DBQ=” & Server.MapPath(“dbGuestbook.mdb”) & “;DefaultDir=” & Server.MapPath(".") & “;DriverId=25;FIL=MS Access;MaxBufferSize=512;PageTimeout=5”
strName=Replace(request(“name”), “’”, “’’”)
strSname=Replace(request(“sname”), “’”, “’’”)
strEmail=Replace(request(“email”),"’", “’’”)
strTel=Replace(request(“tel”), “’”, “’’”)
strAddrs=Replace(request(“addrs”), “’”, “’’”)
strCity=Replace(request(“city”), “’”, “’’”)
strCntry=Replace(request(“cntry”), “’”, “’’”)
strInsertSQL=“Insert Into tblGuestBook (fldName,fldSname,fldEmail,fldTel,fldAddrs,fldCity,fldCntry) Values (’” & strName & “’,’” & strSname & “’,’” & strEmail & "’,’ " & strTel & “’,’” & strAddrs & “’,’” & strCity & “’,’” & strCntry & “’, )”
if strName<>"" and strEmail<>"" then
Set DBConn = Server.CreateObject(“ADODB.Connection”)
DBConn.Open strDB
DBConn.execute strInsertSQL
response.write “iSuccess=1”
Else
response.write “iFailed=1”
End If
DBConn.close
Set DBConn=Nothing
%>
anyone?!?
