HOWTO: Change Information in a Database from ASP

ID: Q188713

The information in this article applies to:

Active Server Pages
Microsoft Visual Studio versions 97, 97sp1, 97sp2, 97sp3
Microsoft Internet Information Server versions 4.0, 5.0

SUMMARY

There are two different methods for performing updates and inserts. One way is to create a recordset and then insert/update its records. The other way is to use the Execute method to issue a SQL statement which inserts/updates the records.

MORE INFORMATION

The code below illustrates opening a recordset and then adding and altering its records. The current location in the recordset determines which record will be updated.


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

The code below illustrates inserting and updating records through the Execute method. The "Where" clause is used to specify which records will be updated. Notice that you do not work directly with a recordset.


   <%
   Set conn = Server.CreateObject("ADODB.Connection")
   conn.Open "DSN=MyDSN"

   ' Insert a record
   conn.Execute("INSERT INTO MyTable(Field1,Field2) VALUES (Value1,
     Value2))

   ' Update a record
   conn.Execute("UPDATE MyTable SET Field1 = Value1 WHERE Field1 = Value2")

   conn.Close
   %>

Additional query words: kbnokeyword

Keywords : kbADO kbASP kbDatabase kbGrpASP kbCodeSnippet kbiis400 kbiis500
Version : WINDOWS:97,97sp1,97sp2,97sp3; winnt:4.0,5.0
Platform : WINDOWS winnt
Issue type : kbhowto