How To Change Information in a Database from ASP (188713)

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 following code 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 next code 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
   %>