# \[FlashCS3\] Need Desperate Help with a GuestBook!

**URL:** <https://forum.kirupa.com/t/flashcs3-need-desperate-help-with-a-guestbook/306518>\
**Category:** Uncategorized\
**Created:** [March 16, 2010, 10:29pm UTC](https://forum.kirupa.com/t/flashcs3-need-desperate-help-with-a-guestbook/306518 "2010-03-16T22:29:53Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Takmelius](https://avatars.discourse-cdn.com/v4/letter/t/82dd89/32.png) [@Takmelius](https://forum.kirupa.com/u/Takmelius)\
**Post date:** [March 16, 2010, 10:29pm UTC](https://forum.kirupa.com/t/flashcs3-need-desperate-help-with-a-guestbook/306518/1 "2010-03-16T22:29:53Z")

</div>

Hey Guys,

I’ve been trying to follow this tutorial and it’s killing me!!!

[http://www.smartwebby.com/Flash\_and\_ASP/](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?!?
