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

    Adding record Flash to ASP to Access

    greatscott90 Level 1
      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.