How To Change Information in a Database from ASP

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

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