by Anonymous (267 Submissions)
Category: Active Server Pages
Compatability: ASP (Active Server Pages)
Difficulty: Unknown Difficulty
Originally Published: Thu 5th August 1999
Date Added: Mon 8th February 2021
Rating: (1 Votes)
How to change information in a database using Active Server Pages (ASP). This method creates a recordset and then inserts/updates its records
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open Session("DSN=MyDSN")
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "MyTable", conn, 1, 3, 2 ' Make sure the LockType
' allows for insertions and updates
' Insert a record
rs.AddNew
rs("Field1") = Value1
rs.Update
' Update the current record
rs("Field1") = Value2
rs.Update
rs.Close
%>
No comments have been posted about How to change information in a database using Active Server Pages (ASP). This method creates a reco. Why not be the first to post a comment about How to change information in a database using Active Server Pages (ASP). This method creates a reco.