0 Replies Latest reply on Oct 23, 2006 4:08 PM by greatscott90

    Adding record Flash to ASP to Access

    greatscott90
      I'm trying to take an input text field and add it to an access database that is residing on the root directory of my ftp web server. That is what I have so far (that doesn't work), if anyone can debug what I'm doing that would be great.
      In Flash. An input box with the variable name: strInput. A button with the following on release code:
      loadVariablesNum("Check.asp", 0, "POST");
      An Access database, a table, and field all named Check and the table has an autonumber which is the primary key.
      And to connect the two, Check.asp:
      Dim Conn
      Dim Rs
      Dim sql
      Set Conn = Server.CreateObject("ADODB.Connection")
      Set Rs = Server.CreateObject("ADODB.Recordset")
      Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Check.mdb")
      sql= "SELECT * FROM Check"
      Rs.CursorType = 2
      Rs.LockType = 3
      Rs.Open sql, Conn
      Rs.AddNew
      Rs.Fields("Check") = Request.Form("strInput")
      Rs.Update
      Rs.Close

      Also - if anyone can tell me a way to pass on the current date and time into the same record that would be helpfull. Thanks in advance.