Results 1 to 3 of 3

Thread: Include and Update Data in the database

  1. #1
    Join Date
    Jun 2007
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Include and Update Data in the database

    Currently i am giving input ( as offline ) to access database locally. After the i upload the whole database.

    But i want to give the as online i.e. i want to give the input to the database from a webform.

    To display the data from the databse in the webform i am using the following recordset:

    Code:
    <%
    Dim recordset, dateR
    Dim recordset_numRows
    
    dateR = dataR
    
    Set recordset = Server.CreateObject("ADODB.Recordset")
    recordset.ActiveConnection = MM_cnTender_STRING
    recordset.Source = "SELECT *  FROM emp_table  WHERE EnterDate LIKE '%" + Replace(dateR, "'", "''") + "%'  ORDER BY EnterDate desc"
    recordset.CursorType = 0
    recordset.CursorLocation = 2
    recordset.LockType = 1
    recordset.Open()
    
    recordset_numRows = 0
    %>
    Should i change anything in the existing databse?

    What will be the recordset property value i.e. the value of CursorType, CursorLocation, LockType to include new data to the database as well as the update of the existing record.

  2. #2
    Join Date
    Aug 2011
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    emm.. hi first.. don't know how to revive the topic.. but i need anybody's advice on the same issue.. no one responded however..

  3. #3
    Join Date
    Aug 2011
    Posts
    18
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default

    I have read it three times and still can't decipher what the question is.

    Dino, maybe you could restate the issue you're having?

Bookmarks

Posting Permissions

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