Determining How Many Records Are Affected
Written by Eric Smith, Northstar Computer Systems LLC
Using the ADO Connection object, you can use the Execute method to run queries. However, it's often helpful to know how many new records were created, updated, or deleted. If you pass a variable into the Execute method as the second parameter, ADO will fill that variable with the number of records that were touched. Here's an example
Dim cnDB ' As ADODB.Connection
Dim lngRecords ' As Long
cnDB.ConnectionString = "some connection string"
cnDB.Open
cnDB.Execute "UPDATE Products SET UnitPrice = UnitPrice * 1.05", lngRecords
The variable lngRecords will hold the number of records that were updated.
Keywords: [
Uncategorized ASP Tips
]
Publication Date: 7/1/2000
|