ADO TutorialLesson 68Free preview

ADO Update

This lesson is part of ASP · All levels

Summary

The data changes are done with the UPDATE query... SET ... WHERE specifies the new column and the row to be changed. Through the Recordset, active line changes are saved by calling the Update method. Queries formed from user input must use parameters to avoid opening SQL injection gaps.

Key points

UPDATE specifies a new column on the SET clause and the target line on WHERE.
Updates without WHERE change the entire row of the table.
The recordset stores the active line changes via rs.Update.
Use parameters, not string combinations, for the value of the user.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.