There are actually several kinds of recordsets. Some are read-only, meaning we can't change the data within them. Some allow us to scroll up and down among the data; some don't. We can control all of those attributes of a recordset when we create it directly using a CreateObject statement instead of letting ASP do it for us, as we have been doing.
Let's look at the issues we need to take into consideration, and then we'll look at syntax. When we create a recordset using
set mySet = Server.CreateObject("ADODB.RecordSet")
we need to set several attributes about it. These attributes will be discussed in the following sections.
The first attribute is the source of the data—where is it coming from? So far we've been using ...