Using update

[johnaregan]

To ask a simple question, how do you use the ADO update on a recordset in ASP?

 

[link9]

First, your recordset must have a lockType declared as something other than the default of adReadOnly(1) --

Then, if you are UPDATEing existing records, just move to the desired record in the recordset, and assign values to the fields like you would for any other variable:

rs("fieldName&quot = value

and then call the .update method on the recordset:

rs.update

to run the update on the database. If you don't call .update, then the changes are made to the rs, but not the database (since the rs is a snapshot of the data, not the actual data).

If you want to add new records to the rs:

rs.addNew
rs("fieldName&quot = value
rs.update

works like INSERT does in a pure SQL type solution.

hope that helped!
Paul Prewett

 

[johnaregan]

Thanks