Microsoft KB Archive/188713

= How To Change Information in a Database from ASP =

Article ID: 188713

Article Last Modified on 8/11/2005

-

APPLIES TO


 * Microsoft Active Server Pages 4.0
 * Microsoft Visual Studio 6.0 Enterprise Edition
 * Microsoft Visual Studio 97 Service Pack 3
 * Microsoft Internet Information Server 4.0
 * Microsoft Internet Information Services 5.0
 * Microsoft Data Access Components 2.5
 * Microsoft Data Access Components 2.6

-



This article was previously published under Q188713



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

Additional query words: kbnokeyword

Keywords: kbhowto kbcodesnippet kbdatabase KB188713

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.