Results 1 to 8 of 8

Thread: Help For Flash Forms and Database Integration

  1. #1

    Help For Flash Forms and Database Integration

    Hi to everybody.
    I found this source file on this site at the page http://www.kirupa.com/developer/acti...s_database.htm

    but the form do not work...

    someone can help me? Can you take a look to understand what's wrong?
    thank you so much.
    Clemi
    Attached Files Attached Files

  2. #2
    1,839
    posts
    Registered User
    does your server have ASP? and do you have a microsoft access Database setup? i have neither ASP or microsoft access....so cant help much

  3. #3
    ^ If the above it true...

    Make sure your database path if correct.
    Code:
    MyPath=Server.MapPath("example.mdb")
    Set conn = Server.CreateObject("ADODB.Connection")
    conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
    "DBQ=" & MyPath
    If that is correct then make sure your Flash URL is correct.
    Code:
    on(press){
    loadVariablesNum("http://yourSite.com/processForm.asp",0,"post");
    }
    On top of that your should use LoadVars() - that tutorial was written 4 years ago.

    edit: Moved to server side

  4. #4
    I use Flash 8.
    I tried all the possible combination but it do not work.
    I tried also the original source file but it do not work
    I don't know if I forgot something in the vars or on the asp...
    can you check the file source I attached?
    thnks

    this is my asp code:

    <%@language = "VBScript" %>
    <%
    strFirst = Request.Form("fname")
    strLast = Request.Form("lname")
    strEmail = Request.Form("email")
    strAddress = Request.Form("address")
    strZip = Request.Form("zip")
    strCountry = Request.Form("country")
    strPhone = Request.Form("phone")

    MyPath=Server.MapPath("example.mdb")
    Set conn = Server.CreateObject("ADODB.Connection")
    conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
    "DBQ=" & MyPath

    SQL = "INSERT INTO contacts (FirstName, LastName, Email, Address, Zip, Country, Phone) VALUES ('"&strFirst&"','"&strLast&"','"&strEmail&"','"&st rAddress&"','"&strZip&"','"&strCountry&"','"&strPh one&"')"
    conn.Execute(SQL)
    %>



    and my Flash URL on the submit botton is:

    on(press){
    loadVariablesNum("http://nobraingroup.com/processForm.asp",0,"post");
    }
    Last edited by clemi; January 25th, 2008 at 07:02 AM.

  5. #5
    ...

  6. #6
    Well if I visit http://nobraingroup.com/nobraingroup/processForm.asp directly I get bounced back to the root of the server which is weird.

    Do a hello world asp file and see if your server at least runs ASP. Not sure what else to see you at this point.

  7. #7
    hello world asp file? what is it?

    just to Know...you have check all the structure of the flash file and the access file?
    because maybe the mistake is there?

  8. #8
    The files from the tutorial work.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Home About kirupa.com Meet the Moderators Advertise

 Link to Us

 Credits

Copyright 1999 - 2012