Everybody! This is important. In a few days, these forums will be moving over to using the totally sweet Discourse platform. To ensure this migration happens smoothly with no loss of content, these forums are currently in a read-only mode. I do apologize for the inconvenience.

There is never a good time to turn the forums off for an extended period of time, but I promise the new forums will be a billion times better. I'm pretty sure of it.

See you all on the other side in a few days, and if you have any (non-technical) questions, please e-mail me at kirupa@kirupa.com. For technical questions, try to find a tutorial that corresponds to what you are looking for and post in the comments section of that page.

Cheers,
Kirupa

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