VBcoders Guest



Don't have an account yet? Register
 


Forgot Password?



How to change information in a database using Active Server Pages (ASP). This method creates a reco

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

Rate How to change information in a database using Active Server Pages (ASP). This method creates a reco



         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
%>

Download this snippet    Add to My Saved Code

How to change information in a database using Active Server Pages (ASP). This method creates a reco Comments

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.

Post your comment

Subject:
Message:
0/1000 characters